topic Re: Lost with missing values. Part II in QlikView

Lost with missing values. Part II

Joaquin_Lazaro — Mon, 24 Nov 2014 09:56:31 GMT

Hello.

This post is the 2nd part of this one Lost with missing values

Following your instructions I get a chart that shows all the dates without a value on the expression.

Now, I need to make a selection over the calendar and show only the selected dates with and whitout their value, not all the dates of the calendar.

I guess, I should modify the expression even create a calculated dimensión but I can't get it works !!!!

How can I get this behaviour changing the chart properties?

Thank you?

Joaquín

Re: Lost with missing values. Part II

JonnyPoole — Mon, 24 Nov 2014 14:00:30 GMT

Would this work ? I added a 2nd dimension but added a mutually exclusive condition on both , only when you have selected an Ano, MonthName, Quarter, Dia or Fecha would you restrict the dates to the selected value. You could further the restriction to just Fecha very easily too

Conditional Show on Fecha dimension with 'show all values':

GetSelectedCount(Año) + GetSelectedCount(MonthName) + GetSelectedCount(Quarter)+ GetSelectedCount(Dia)+GetSelectedCount(Fecha)=0

Conditional Show on Fecha dimension WITHOUT 'show all values':

GetSelectedCount(Año) + GetSelectedCount(MonthName) + GetSelectedCount(Quarter)+ GetSelectedCount(Dia)+GetSelectedCount(Fecha)>0

Re: Lost with missing values. Part II

Joaquin_Lazaro — Wed, 10 Dec 2014 08:24:40 GMT

Hi jpe

First of all I want to excuse me about my silence, I've been working full time in a high priority project.

I've been testing the doc you sent me some weeks ago, my answer is "it doesn't work neither, it has de same problem".

Please, try to select NOV-2014 and website = de-DE, there isn't any value for date 16/11/2014 ... but I need to show a point over de x-axis with the 0 value associated, as I show with a red line on the attached image.

Would you mind have a look when you will be able to ?

Thank you

Joaquín

Re: Lost with missing values. Part II

JonnyPoole — Wed, 17 Dec 2014 15:28:29 GMT

Hi Joaquin - sorry for the silence. I saw your note. Will get to this as soon as the pre-holiday work rush is over

Re: Lost with missing values. Part II

Joaquin_Lazaro — Wed, 17 Dec 2014 15:40:27 GMT

Hi:

Don't worry, It's not urgent.

Anyway, thank you very much.

Joaquín