This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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:
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 🙂
you need to first create all dates in script and later
View solution in original post
simple way is
set Null Symbol to 0 and set the text alignment to right
Follow this blog post: How to populate a sparsely populated field
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?
the toggle in the Dimensions was the right one 🙂