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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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])