Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
smiling_cheetah
Contributor

Replicate IF(SUM(fieldA)>0, SUM(fieldB)) with set analysis

Hi everyone,

Sorry if this is repeated question, but I couldn't find a related topic and would appreciate any help with this one.

So I got a table looking like following

T:
Load * inline [
date, agent, type, goal, act
01.01.2019, A, 1,, 120
01.01.2019, A, 2, 100,
02.01.2019,	A, 1,,150
02.01.2019, A, 2,,90
01.01.2019, B, 1,, 0
01.01.2019, B, 2, 120
02.01.2019, B, 1,, 0
02.01.2019, B, 2, 140
];

The ultimate goal is to create a bar chart:

dimension=agent

measure1=sum(act)

measure2=sum(goal)

But to show only those agents, which have their sum(act)>0.

(Thus the chart will not show agent=B)

 

The basic solution I could find is to turn off zero values in chart settings and modify:

measure2=IF(SUM(act)>0, SUM(foal))

But can the same effect be achieved by set analysis (to get rid of IF clause)? 

 

Thanks in advance

Labels (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Replicate IF(SUM(fieldA)>0, SUM(fieldB)) with set analysis

Try this

Sum({<agent={"=Sum(act)>0"}>}goal)
2 Replies
MVP
MVP

Re: Replicate IF(SUM(fieldA)>0, SUM(fieldB)) with set analysis

Try this

Sum({<agent={"=Sum(act)>0"}>}goal)
smiling_cheetah
Contributor

Re: Replicate IF(SUM(fieldA)>0, SUM(fieldB)) with set analysis

Thanks!
Works as intended 🙂