Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get only the y value who is greater than 1

Hello qlikers 🙂 ,

I have this chart. 

Unbenannt2.PNG

Blue, yellow and red are x. The yellow should only have the x value and with all y values they are greater than 1.

So the x value should be smaller.

How can I do that? Thank you in advance! 🙂

Labels (1)
1 Reply
Anil_Babu_Samineni

Since Qlik graph will start with the X-Axis point starting from 0. I would suggest to create another measure with the Yellow expression. Let's say your Yellow expression is

Sum(Yellow)

Then, create one more expression 

Sum(Yellow) and use BG color for that, If(Sum(Yellow)<=1, White())

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful