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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Parry2k,

Thank you. You are close to my requirement. Columns are text.

 

I would like to use this 

values(para[para])

in Column C2 Visual filter. Is there any way to do this?

 

When i use Values(Para[Para])  in the visual filter its not considering.

parry2k's avatar
parry2k
Icon for Super User rankSuper 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.