Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

using parameter values in visual filter

Dear experts   I have a requirement. I have defined a parameter named Para in the query editor and applied the same on column C1 , in Table T1.   In the dashboard, i have a visual based on Table ...
  • parry2k's avatar
    parry2k
    8 years ago

    try this:

     

    add new column :

     

    Filter c2 = if(t2[c2]=Values(para[para]),1,0)

    and in visual filter use where "Filter C2" = 0

parry2k's avatar
parry2k
Super User
8 years ago

try this:

 

add new column :

 

Filter c2 = if(t2[c2]=Values(para[para]),1,0)

and in visual filter use where "Filter C2" = 0

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you Parry2k, this works.