I haven't used Qlik for a long time and I'm facing an "issue" with it. I'll try to explain myself:
- Table A : year,month,city and sales(total)
- Table B : year,month, product and revenue (total)
I want to create a crosstab with:
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.