Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
New Contributor III

Show rows with no values


I have two tables Assortiment and Data with association on item_key. How to get Result table as below with filter on assort_category? What I need to change - data model or measure calculation sum(sales)? There is millions rows in both tables, so i need to think for performance too.




Tags (1)
1 Reply
Contributor III

Re: Show rows with no values


there is not perfect key, which means that some values cannot be paired with values from second table. And that is the reaso why you see what you see.


I don't know the logics behind your data model so it is difficult to tell what to change. Could you try to explain in more details?