2 Replies Latest reply: Feb 26, 2016 4:15 PM by Luiz DePaula RSS

    If condition on a dimension

    Luiz DePaula

      Hello experts,

       

      I am new to Qlik Sense and I am having many challenges. One of them is to restrict the set of values without having to use a measure.

       

      For example, I have a table with Cities and many measures that follow based on the city, like sales, budget, and so forth.

       

      Each sales person is responsible for a set of cities, so they need to have dashboards and reports customized for them, just with their cities showing on their table, without having to select from the filter.

       

      I can use set analysis on each measure (calculation) and define the set of cities per measure, but it is a lot of work. So, I was wondering if I could define the amount of values from a dimension, and all the measures will follow the selection.

       

      I was trying to use something like:

       

      if(isnull(getfieldselections([City])),[City]='Chicago',[City])

      or

      if(Getselectedcount([City])=0,[City]='Chicago',[City])

       

      But the statements above return no values. What am I missing?

      Thanks for the help in advance.