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

why you cannot use the parameter in query editor to filter records in t2 as you did for t1?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for the reply. Since there are other visuals based on T2, i cannot filter at query editor level. Hence looking for way to filter at visual levels.

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      try this:

       

      1. Turn on Enabled Load on edit queries for parameter.

      2. Add new measure called "filter c2" in your table t2,

      filter c2 = sum(c2) - values(para[para])

      , assuming para is a number parameter and c2 is number column as well.

      3. Add "filter c2" measue to visual filter and chooise the filter condition, like "Filter C2" is greate than 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.