Show zero values in table

[AnneEb]

Hello everyone, 

I have a table that lists products and their sales volumes over the last twelve months rolling. 
Kinda looks like this:

Now when I select a customer, the products that have not been purchased during the last twelve months by that customer disappear. In the example above, the second record would hence not show up anymore. Is there a way to keep those records in the table? Simple ticking the "show null values" sadly does not do the trick.

Thank you in advance for all your answers. 

[robert_mika]

Did you try this option:

[AnneEb]

Tried it with a customer that did not buy any products in the last 12 months. The table shows up as empty. 

[marcus_sommer]

Existing records with ZERO could be displayed but missing ones not because there is NOTHING what could be shown.

You may try approaches like:

rangesum(MyExpression, sum({1} 0))

but this will be working only for a few scenarios.

Within the most cases it's necessary to populate the missing records: Generating Missing Data In QlikView - Qlik Community - 1491394