Unable to see dimensions for zero values in Qliksense Table

[SatyaPaleti]

Hi Experts,

Could you please some one can help me to resolve following Issue.

Currently we are having a product and it's Sales. Sales were updating every week. So we want to show Product and current week sales.

So I am using Product as Dimension and in Expression following code I am using

sum({<Year = {'2020'},week={"$(=Week(max(Today())))"}>}Sales)  

But in Current week Sales has not yet uploaded. Then it have to show a Table Like Product and 0 as a values.  But I am getting following Table

But I need a Table to see like below

Can some one please help to resolve this Issue. I have already checked Include zero values in Adds-on but it's not working.

You can find sample qvf file. Please help me to resolve this Issue

Thanks and Regards,

Satya

[Taoufiq_Zarra · Accepted solution]

attached new version :

[SatyaPaleti · Accepted solution]

Thank you so much brother. It's work as expected 

[Srivanik09]

Hi,

Actually I'm facing the same issue, but unable to open the QVF file. Can you post the answer here to solve this.

Thanks,

Srivani K

[SatyaPaleti]

Hi SriVani,

Here is the expression we have used.

sum(aggr(sum({<Year = {'2020'},week={"$(=Week(max(Today())))"}>}Sales),Product))

Thanks,

Satya