Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
malmsteen1977
Partner - Contributor
Partner - Contributor

Fill up missing date values

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:

DateValue

05.01.2017

0
06.01.20170
07.01.20170
08.01.20170
09.01.20170
10.01.20170
11.01.20170

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

1 Solution

Accepted Solutions
annafuksa1
Creator III
Creator III

you need to first create all dates in script and latervisi.png

View solution in original post

7 Replies
dsharmaqv
Creator III
Creator III

simple way is

properties>presentation tab>

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

malmsteen1977
Partner - Contributor
Partner - Contributor
Author

Unfortunately not

20170302_Date_Amount2.jpg

tresesco
MVP
MVP

malmsteen1977
Partner - Contributor
Partner - Contributor
Author

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?

annafuksa1
Creator III
Creator III

you need to first create all dates in script and latervisi.png

malmsteen1977
Partner - Contributor
Partner - Contributor
Author

Hi Anna,

the toggle in the Dimensions was the right one 🙂

Many thanks.

annafuksa1
Creator III
Creator III

No Problem