Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Death4Free
Contributor III
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

 

 

1 Reply
DavidŠtorek
Creator III
Creator III

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?