topic Re: Fill up missing date values in QlikView

Fill up missing date values

malmsteen1977 — Thu, 02 Mar 2017 10:10:30 GMT

Hi all,

i have a very simple report, screenshot is attached

Dimension is Date

Expression is in the screenshot also

My challenge is that I want to fill up all the dates that are missing in the chart with the value 0

For example I want to have the dates between the 04.01.2017 and the 12.01.2017 filled up with the missing dates (05.01-11.01) and the value 0, something like this:

Date	Value
05.01.2017	0
06.01.2017	0
07.01.2017	0
08.01.2017	0
09.01.2017	0
10.01.2017	0
11.01.2017	0

I can't do this in the script because of the set analysis in the expression, otherwise I would choose the "peek"-Function.

Suppress Null-Values is deactivated everywhere

Thanks for some input 🙂

Hannes

Re: Fill up missing date values

dsharmaqv — Thu, 02 Mar 2017 10:45:52 GMT

simple way is

properties>presentation tab>

set Null Symbol to 0 and set the text alignment to right

Re: Fill up missing date values

malmsteen1977 — Thu, 02 Mar 2017 10:49:21 GMT

Unfortunately not

Re: Fill up missing date values

tresB — Thu, 02 Mar 2017 11:29:17 GMT

Follow this blog post: How to populate a sparsely populated field

Re: Fill up missing date values

malmsteen1977 — Thu, 02 Mar 2017 11:32:22 GMT

Hi Treseco

I know this posting. As I said in my first posting, I have to do this inside the expression of the diagram, not in the script.

Any other ideas?

Re: Fill up missing date values

annafuksa1 — Thu, 02 Mar 2017 11:44:31 GMT

you need to first create all dates in script and later

Re: Fill up missing date values

malmsteen1977 — Thu, 02 Mar 2017 11:46:19 GMT

Hi Anna,

the toggle in the Dimensions was the right one 🙂

Many thanks.

Re: Fill up missing date values

annafuksa1 — Thu, 02 Mar 2017 12:13:33 GMT

No Problem