Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Dafna
Contributor
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!

YoYYoY

 

Labels (2)
1 Solution

Accepted Solutions
Dafna
Contributor
Contributor
Author

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

View solution in original post

1 Reply
Dafna
Contributor
Contributor
Author

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