Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Chart - Condition in DIMENSION

Hi,

I would like to insert a condition in the dimension of a chart.

In the attached example i have used "=if(TYPE=1,DEVICE)"

Everything works fine in the first chart where i set the EXPRESSION = POWER. I can see just the line that i want

In the second chart i set the EXPRESSION = "Sum(POWER)" and i can see 2 lines:

- one is fine (the same of the first chart) that is the sum of power where TYPE = 1

- the other is the sum of the power that have TYPE != 1
I don't want represent that line. How can i do ?

Are there better way of doing all this ?

Thanks.

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

What you are seeing is the NULL value for all those tows where your condition is FALSE. You can suppress the NUL values with the check box on the Dimensions tab: "Suppress when the value is null".

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy and Austin, TX!

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

What you are seeing is the NULL value for all those tows where your condition is FALSE. You can suppress the NUL values with the check box on the Dimensions tab: "Suppress when the value is null".

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy and Austin, TX!

sunny_talwar

Select 'Suppress When Value is Null' for your second dimension (If(TYPE = 1, DEVICE))

Capture.PNG