Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielrogra
New Contributor III

Associative model & Filter one chart

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         

Tags (2)
1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Associative model & Filter one chart

you can get it using set analysis in your expressions.

ex.

sum( {< City = >} Revenue )

sum( {< Product = >} Sales )

2 Replies
agigliotti
Honored Contributor II

Re: Associative model & Filter one chart

you can get it using set analysis in your expressions.

ex.

sum( {< City = >} Revenue )

sum( {< Product = >} Sales )

danielrogra
New Contributor III

Re: Associative model & Filter one chart

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