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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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