topic Re: Missing some data that needs to be there. in QlikView

Missing some data that needs to be there.

b04nhu13 — Fri, 25 Apr 2014 08:30:49 GMT

I have a simple sql database that contains fowling fields.

Bolag, DATUMST, KLOCKANST, KLOCKANOP, Timmar

What it shows is how long time a company (bolag) is unavailable , Time stop (KLOCKANST), timestart (KLOCKANOP) and approved downtime (timmar)

In the script I just load it

SLA:
LOAD
BOLAG,
DATUMST,
KLOCKANST,
KLOCKANOP,
Timmar,
Orsak;
SQL SELECT *
FROM "SLA".dbo.Rapportunderlag;

I also connect a master calendar to it.

Then in the graph I do some calculations to show it like this.

But as you can see some dates are missing, and that is because the database doesn’t contain all dates. And when it is missing it means that uptime is 100%. If I show “ All values” then I get 31 days in February. So how will I solve it ? I think I need to add data within the scrip but how.

Re: Missing some data that needs to be there.

Gysbert_Wassenaar — Fri, 25 Apr 2014 12:04:47 GMT

Have you tried enabling the options Suppress When Value Is Null and Show All Values for the Dag dimension?

Re: Missing some data that needs to be there.

b04nhu13 — Fri, 25 Apr 2014 12:07:15 GMT

Yes and it wont change anything

Re: Missing some data that needs to be there.

maxgro — Fri, 25 Apr 2014 12:09:11 GMT

Re: Missing some data that needs to be there.

b04nhu13 — Fri, 25 Apr 2014 12:16:36 GMT

If I "Show All values” then I get 31 days in February.