Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Dafna
New Contributor

Ignore null in a bar chart with years comparison

Hi,

I have a demand to display a bar chart where every bar is showing the difference from the previous year.

sum({<Date ={">=$(vYearStartPrev4)"}>} SalesInvoice_Line_TotalPriceUSD)
/
Above(sum({<Date ={">=$(vYearStartPrev3)"}>} SalesInvoice_Line_TotalPriceUSD))-1

I need to show data  from 2016 only. 

How do I get rid of 2015?

 

Thanks!

Year_Comparison.pngYoY

 

Labels (3)
1 Solution

Accepted Solutions
Dafna
New Contributor

Re: Ignore null in a bar chart with years comparison

The solution is to uncheck the  Include zero option in the Add-ons tab.

1 Reply
Dafna
New Contributor

Re: Ignore null in a bar chart with years comparison

The solution is to uncheck the  Include zero option in the Add-ons tab.