2 Replies Latest reply: Sep 15, 2017 4:04 AM by Daniel Rodríguez RSS

    Associative model & Filter one chart

    Daniel Rodríguez

      Hi all. First of all thank you for your time.

       

      I haven't used Qlik for a long time and I'm facing an "issue" with it. I'll try to explain myself:

       

           SITUATION:

                               - Table A : year,month,city and sales(total)

                               - Table B  : year,month, product and revenue (total)

       

      I want to create a crosstab with:

       

                     Rows: Month

                     Columns: Sales and Revenue

                      Filters: City, product and year

       

      The issue is the following: I'd like to filter by city and only be changed sales, filter by product and only be changed revenue and filter by year and change both. As qlik uses associative models, when I filter by City then revenue is also changed.


      Is there a way to do this? If i haven't explained myself well just let me know and I'll try to explain myself again.


      Thank you very much for your time


      Daniel