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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
victor_jacquens
Contributor II
Contributor II

Combo Chart Markers visibility condition

Hello,

I have a combo chart on my app that displays the stock of products by class, and I would like to add a marker for stock limit on some of them. I've used the marker option to do so but I wanted to know if it was possible to hide the makers where the limit value is 0 (when the limit is 0, there is no limit).

Here's how it looks for now:

victor_jacquens_0-1616682208469.png

Is there any option or expression condition to only keep the markers I want?

 

Thanks in advance

1 Reply
victor_jacquens
Contributor II
Contributor II
Author

Hello everyone,

I have found a solution. Since I only have 1 "Stock Limit" value per product category, and since when there is no limit, the "Stock limit" column is empty, I switched the marker expression from "Sum([Stock Limit])" to "Avg([Stock Limit])", since the average of nothing is nothing, where the sum of nothing was 0.