Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (2)
1 Reply
Highlighted

Re: Get only the y value who is greater than 1

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())

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)