topic Re: Unable to see dimensions for zero values in Qliksense Table in App Development

Unable to see dimensions for zero values in Qliksense Table

SatyaPaleti — Sat, 16 Nov 2024 18:37:50 GMT

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 — Sun, 17 May 2020 13:26:07 GMT

attached new version :

SatyaPaleti — Sun, 17 May 2020 14:17:39 GMT

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

Srivanik09 — Mon, 08 Aug 2022 13:59:12 GMT

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 — Mon, 12 Sep 2022 03:46:43 GMT

Hi SriVani,

Here is the expression we have used.

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

Thanks,

Satya