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 am quite annoyed with my bar chart.
I have a list of products sold with a discount or not.
Product, Nb sell with discount, nb sell without discount, average amount of price of discount
I have a problem in my bar chart to show the Pen value. I have my product as dimension and my expression is
dual('Nb sell with discount :' & count([Nb sell with discount]), avg([amount of price of discount]) )
but because my average amount for pen is null, it is not showed in my graph.
My question is how to show Pen with a label Nb sell with discount : 0 even my expression avg([amount of price of discount]) is null ?
Thank you so so much for your help,
May be try alt(avg([amount of price of discount]),0) to have value 0 in case expression results into null.