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

[ysalvi43]

Hello 
Need some clarification, in the front end if you can using Pivot table. then there are some Transformation steps you will have to do. 

If you are going with Pivot table in front end:
1) Convert above Pivot table to unpivot table using cross table

2) create cross table between Customer and Year Month using 'Linkage' (you can provide any flag this will create combination of Customer and year month 

3) Join Table 2 which you have created in step 2 to the unpivot table 

4) In the front end plot dimension and year month as column and measure as per your requirement 

For step 2 Reference you can you this link: https://community.qlik.com/t5/Data-Quality/Remove-Rows-with-Nulls-and-Zeros/td-p/2535292

Please don't use whole script, use this script only till Table name: Null_table

Thanks