Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
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.
Death4Free
New Contributor III

Show rows with no values

Hi,

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.

Capture.PNG

 

 

Tags (1)
1 Reply
Highlighted
DavidŠtorek
Contributor III

Re: Show rows with no values

Hi,

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.


Capture.PNG

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?