Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Thanks,
Srinivas
Labels (1)
1 Solution

Accepted Solutions
Highlighted

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

Change your expression to this

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

image.png 

View solution in original post

4 Replies
Highlighted

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

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

Highlighted
Creator
Creator

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

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

 

 

 

Thanks,
Srinivas
Highlighted
Creator
Creator

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

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

Thanks,
Srinivas
Highlighted

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

Change your expression to this

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

image.png 

View solution in original post