topic Displaying Null Values in Qliview in QlikView

Displaying Null Values in Qliview

SK28 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In the attached dashboard I'm having data only on 06/11/2016, 06/222016, 06/23/2016 (MM/DD/YYYY) dates.

I want to Display the Data with Null Values in the Dashboard.

i.e ; it has to Show 06/01/2016,2,3,4 ... so on till 30th June(in dashboard) with zero or Null value

similarly for all the months.

Please help me through this issue.

Attached a Screenshot of Dashboard and Expected output. Please go through it.

Thanks,

Krishna

Re: Displaying Null Values in Qliview

sunny_talwar — Wed, 21 Sep 2016 17:25:10 GMT

Have you tried Unchecking 'Suppress Zero Value' on the presentation tab? If that alone doesn't work, may be try adding + Avg({1} 0) to your expression

YourExpression + Avg({1} 0)

Re: Displaying Null Values in Qliview

SK28 — Thu, 22 Sep 2016 09:58:52 GMT

Hi Sunny,

Thanks for you reply,

But it is not working. Still some of the Dates are missing and it is showing all months Data. Example in April (2,3,4) are missing so on

Re: Displaying Null Values in Qliview

sunny_talwar — Thu, 22 Sep 2016 16:20:23 GMT

Would you be able to share a sample to look at this?

Re: Displaying Null Values in Qliview

SK28 — Fri, 23 Sep 2016 12:02:44 GMT

I was trying to attach a dashboar but their is no such option

Re: Displaying Null Values in Qliview

SK28 — Fri, 23 Sep 2016 12:04:03 GMT

Can you please provide me your mail ID so that I can Forward you my QVW file

Re: Displaying Null Values in Qliview

sunny_talwar — Fri, 23 Sep 2016 16:01:18 GMT

Here is how you can upload a sample

Uploading a Sample