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: 
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.