Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Bar Chart - Show Null Value with a dual() expression

Hello All,

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

Pen, 0,2,-


Mask ,1,0,10


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,




1 Reply

May be try alt(avg([amount of price of discount]),0) to have value 0 in case expression results into null.