Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
roisolberg
Creator
Creator

Set analysis - excluding the intersection

Hi All,

 

i am trying to filter out some troublesome lines,

i want to sum a field 'LineCount' but to exclude if the  ActionType='Close' and the LineStatus='1' 

So basicly i want to sum the red part in the drawing below:

Intersection.jpg

what is the correct syntax for using set analysis in this case? 

 

Thanks,

Roi

 

 

 

 

Labels (3)
1 Solution

Accepted Solutions
rubenmarin

Hi, can you try this?
sum({<LineStatus-={1}>+<ActionType-={'Close'}>} LineCount)

View solution in original post

5 Replies
OmarBenSalem
Partner
Partner

Woul it be possible to share some sample data, 5 lines of data maybe? with the expected output and result?

You'll ALWAYS get much more responses from the community if you're willing to share sample data or construct an inline table..

 

 

try : 

1) Sum({<LineStatus={1},ActionType={'Open'}>+<ActionType={'Close'},LineStatus={0}>}Value)

or

2) Sum({<LineStatus={1}>/<ActionType={'Close'}>}Value)

Result:

Capture.PNG

Somasundaram
Creator III
Creator III

you can try this,

 

=sum({$<ActionType={'Close'}>/<LineStatus={1}>}LineCount)

 

 

 


-Somasundaram
rubenmarin

Hi, can you try this?
sum({<LineStatus-={1}>+<ActionType-={'Close'}>} LineCount)

View solution in original post

sunny_talwar

You can also try this

Sum({
<LineStatus = {'1'}>
+
<ActionType = {'Close'}>
-
<LineStatus = {'1'}, ActionType = {'Close'}>
} Measure)
roisolberg
Creator
Creator

Thank you all for your effort and assistance!