topic Re: Missing values on time dimension in QlikView

Missing values on time dimension

0li5a3a — Tue, 19 Sep 2017 14:57:09 GMT

Hi all,

I would like someone to help me to display a calendar month if I don't have data. I read all the topics but I couldn't find an answer.

Please find the attached files they contain some data.

I want to display all the month-year even I don't have data in that month. I tried to add an extra expression and uncheck all the buttons to don't display the data but in the legend I still can see the nulls .... This is annoying and I need to display the months where we don't have any data. As far as I understand QlikView can't handle this. I want to thank you in advance.

Regards C

Re: Missing values on time dimension

sunny_talwar — Tue, 19 Sep 2017 15:02:37 GMT

When data isn't available, QlikView cannot display it... check here:

Generating Missing Data In QlikView

Re: Missing values on time dimension

0li5a3a — Wed, 20 Sep 2017 08:59:22 GMT

Hi Sunny,

Thanks you for your files but I still don't understand how to generate the missing values.

Regards,

Re: Missing values on time dimension

hari8088 — Wed, 20 Sep 2017 09:34:24 GMT

deselct Suppress zero values for presentation tab .

Re: Missing values on time dimension

0li5a3a — Wed, 20 Sep 2017 09:57:43 GMT

I done this but this doesn't works.......

Re: Missing values on time dimension

hari8088 — Wed, 20 Sep 2017 11:21:38 GMT

It's working for me.....

See the attached qvw...

Re: Missing values on time dimension

antoniotiman — Wed, 20 Sep 2017 11:49:33 GMT

Calculated Dimension instead of Progress like this

=If(IsNull(Progress),'',Progress)

Re: Missing values on time dimension

0li5a3a — Wed, 20 Sep 2017 15:34:47 GMT

Thanks Antonio

Re: Missing values on time dimension

0li5a3a — Wed, 20 Sep 2017 15:37:41 GMT

Thanks Hari, I used Antonio version for my code which works perfect.