Associative model & Filter one chart

[danielrogra]

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         

[agigliotti · Accepted solution]

you can get it using set analysis in your expressions.

ex.

sum( {< City = >} Revenue )

sum( {< Product = >} Sales )

[danielrogra]

That's great! Thanks for your time and effort!