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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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.