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

    If condition on a dimension

    Luiz De Paula

      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:






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

      Thanks for the help in advance.