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

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

Srinivas — Sat, 16 Nov 2024 00:38:06 GMT

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 :

Please find the sample data file and qvws file.

Regards,

Munna

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

sunny_talwar — Wed, 20 May 2020 13:10:54 GMT

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

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

Srinivas — Wed, 20 May 2020 13:36:49 GMT

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

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

Srinivas — Thu, 21 May 2020 11:01:37 GMT

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:

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

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

Thanks,

Srinivas

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

sunny_talwar — Thu, 21 May 2020 11:34:15 GMT

Change your expression to this

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