Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Srinivas
Creator
Creator

Want to display continuous date values as Zero if data is not available in Main fact table

Hi Team, 

I want to display the dates continuously if data is not available in final fact table, I have tried based on  master calendar but not shows the continuously dates values. 

I am expecting below output like that so on :

Srinivas_0-1589979330728.png

Please find the sample data file and qvws file.

Regards,

Munna

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Change your expression to this

Sum(Sales)+Sum({1}0)

image.png 

View solution in original post

4 Replies
sunny_talwar

One way would be to uncheck 'Suppress Zero-Values' on the presentation tab of the chart properties.

Srinivas
Creator
Creator
Author

Thanks for replay, 

This is the simple application we can unchecked suppress zero values in presentation level and see the all values.

In my real time app have very big data and based on fact table date filed i have created the master table and tried all possible types. But that application doesn't shows the null values where miss the data.

Please let me know, Any other way to solve the problem..

Regards,

Munna

 

 

 

Srinivas
Creator
Creator
Author

Hi Sunny,

Initially we can see all the data but when I selected the any filter i can see only limited dates values only not continuous values.

Initially shows me like:

Srinivas_0-1590058244400.png

1. when I selected any filter:shows me below out put but I need continuously dates with null values(0).

Srinivas_1-1590058460399.png

Even I tried multiple ways but i can get the continuous dates with all values. 

 

Thanks,

Srinivas

sunny_talwar

Change your expression to this

Sum(Sales)+Sum({1}0)

image.png 

View solution in original post