Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
SatyaPaleti
Creator III
Creator III

Unable to see dimensions for zero values in Qliksense Table

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

 

issue.PNG

 

But I need a Table to see like below

SatyaPaleti_0-1589699782284.png

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

 

 

 

 

 

2 Solutions

Accepted Solutions
Taoufiq_Zarra

attached new version :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

SatyaPaleti
Creator III
Creator III
Author

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

View solution in original post

4 Replies
Taoufiq_Zarra

attached new version :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
SatyaPaleti
Creator III
Creator III
Author

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

Srivanik09
Partner - Contributor
Partner - Contributor

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
Creator III
Creator III
Author

Hi SriVani,

 

Here is the expression we have used.

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

SatyaPaleti_0-1662954356919.png

 

Thanks,

Satya