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: 
m_perreault
Creator III
Creator 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

3 Replies
Chanty4u
MVP
MVP

try this



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

YoussefBelloum
Champion
Champion

Hi,

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

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

sunny_talwar

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