Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
m_perreault
Contributor III

Set Analysis Where Sum >0

Hi All,

I have the following table and I would like to use set analysis to include only ID's where all of the measures are > 0.   Does anyone have any suggestions?


ID          Measure 1      Measure 2      Measure 3

1                  10                    0                    5    

2                    5                    5                    5

3                    0                    3                    6

4                    10                  15                  20

So ideally my resulting table would be

ID       Measure 1       Measure 2      Measure 3

2             5                         5                    5

4             10                       15                 20 

Thanks!

Mark

Tags (1)
3 Replies
Highlighted
Chanty4u
Esteemed Contributor III

Re: Set Analysis Where Sum >0

try this



Count({< Field= {"=Sum(Sales) > 0"} >} DISTINCT Field)

Highlighted
YoussefBelloum
Esteemed Contributor

Re: Set Analysis Where Sum >0

Hi,

the set analysis part on your expression(s) would be this:

{<ID={"=Sum(MeasureX)>0"}>}

Re: Set Analysis Where Sum >0

May be this

Sum({<ID = {"=RangeMin(Sum([Measure 1]), Sum([Measure 2]), Sum([Measure 3])) > 0"}>}[Measure 1])

Sum({<ID = {"=RangeMin(Sum([Measure 1]), Sum([Measure 2]), Sum([Measure 3])) > 0"}>}[Measure 2])

Sum({<ID = {"=RangeMin(Sum([Measure 1]), Sum([Measure 2]), Sum([Measure 3])) > 0"}>}[Measure 3])