4 Replies Latest reply: Jul 15, 2016 3:54 AM by Mattias Albinsson RSS

    Graphs and filter - issue

    Mattias Albinsson

      Hi all,

       

      Very new to Qlik Sense and have some issues regarding graphs and filters.

       

      I have 3 filters: Country, Region and City.

       

      I want to make three bar graphs:

       

      1. Shows the income/cost on country level and it should stay the same regardless of filter. I have solved this by using Sum({1}inc)/Sum({1}cost) and it works.

       

      2. Should show region and follow the filter. So if country 1 is selected the it should only present the regions for country 1. This was easy but the problem is that if I then pick a city I want the graph to still present all the regions in the country. This I have not been able to create.

       

      3. Same as graph 2 but for city. Same issue here that if I pick a city, all other cities are removed and I have nothing to benchmark agains anymore.

       

      Thanks in advance for any help that could point me in the right direction.