topic Re: Lost with missing values in QlikView

Lost with missing values

Joaquin_Lazaro — Fri, 21 Nov 2014 15:40:54 GMT

Hello guys:

I have the attached an app with a Fact Table and a master calendar.

I have created an evolution chart based on the calendar date, and it works with data but what happens when I choose the WebSite de-DE ??

I can see the 16th day in the x-axys but I can't see the 0 value, this WebSite has not information for this day.

I need help. What should I do to see this missing 0 value for 16th ?

I've tried joinning this two tables with LEFT, RIGHT, INNER, OUTER, and NATURAL (only JOIN) but it doesn't work.

Thank you very much,

Joaquín

Re: Lost with missing values

JonnyPoole — Fri, 21 Nov 2014 17:36:17 GMT

The website has no data for this day so the join to the calendar table will not result in a date.

In this situation, you have to force the dimension to show 'all values' (below) and the missing values will show as zeroes (as you have already correctly unselected 'suppress zero values' on presetnation tab)

Re: Lost with missing values

MarcoWedel — Sun, 23 Nov 2014 01:33:17 GMT

Hi,

another solution could be to add a term, that delivers (zero-)values at the missing dates:

But of course the "Show all values" check box is the better choice ...

hope this is of any interest nevertheless

regards

Marco

Re: Lost with missing values

ashfaq_haseeb — Sun, 23 Nov 2014 06:17:38 GMT

Like this

Regards

ASHFAQ

Re: Lost with missing values

Joaquin_Lazaro — Mon, 24 Nov 2014 07:33:09 GMT

Hi jpe

Check "Show all values" hasn't been enoughm the chart still the same.

But, thank for help

Joaquín

Re: Lost with missing values

Joaquin_Lazaro — Mon, 24 Nov 2014 07:44:55 GMT

Hi Jonathan Poole

Sorry Jonathan, it works. I have just checked the option in a wrong version of the app

Thanks again.

Joaquín

Re: Lost with missing values

Joaquin_Lazaro — Mon, 24 Nov 2014 08:04:21 GMT

Thanks also to MarcoWedel and ashfaq_haseeb

Re: Lost with missing values

Joaquin_Lazaro — Mon, 24 Nov 2014 10:00:05 GMT

Hi guys:

I need a bit more help.

I've created this new post Lost with missing values. Part II

Thank you for your help.

Joaquín