Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (3)
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.