Displaying Null Values in Qliview

[SK28]

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

[sunny_talwar · Accepted solution]

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)

[SK28]

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

[sunny_talwar]

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

[SK28]

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

[SK28]

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

[sunny_talwar]

Here is how you can upload a sample

Uploading a Sample