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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two calculations in Single Dimension for a Pie Chart

I am trying to create a Pie Chart which should give me two sections-Blocked and Not Blocked based on the following two conditions

Condition 1:

If([Lifecycle1]>0,'Blocked','Not Blocked')

Condition 2:

If([Lifecycle2]>0,'Blocked','Not Blocked')

Here is what I am doing to get this done. I have created a Dimension with the following expression inside it.

=if([Lifecycle1]>0
OR
[Lifecycle2]>0,'Blocked','Not Blocked')

And in the Expressions, I am using

Count(Distinct([Application ID]))

The pie chart gives me two sections with Blocked and Not Blocked. When I select the Not Blocked, the whole pie changes to Not Blocked, which is fine. But when I select Blocked section of the pie, it returns both Blocked and Not Blocked. What is the issue

10 Replies
Not applicable
Author

I am so sorry Swuehl. I might have missed it. Thanks, this fixes the issue. I really appreciate your help and time.