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