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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis with exclusion

Hi Guys,

I would like to create an expression of sum of  "ImpressionAction" in the  dates between the variables "vYeasterday" and "v3days" (this works fine on it own) AND excluding 2 partners id: 221, 2019.

Can you tell me the correct syntax?

sum({1<DateOnly= {"<=$(=vYesterday) >=$(=v3days)"}, partner_id-={221,1019}>} ImpressionAction)

Again, without exclusion, when selection only the dates between the variables it works fine.

Thank you!

1 Solution

Accepted Solutions
aveeeeeee7en
Specialist III
Specialist III

Hi Elula

Try any 1 of the Expression as per your requirement:

1) sum({1<DateOnly= {"<=$(=vYesterday) >=$(=v3days)"}, partner_id={'*'}-{'221','1019'}>} ImpressionAction)

2) Sum({<DateOnly= {">=$(=vYesterday)<=$(=v3days)"}, partner_id={'*'}-{'221','1019'} >} ImpressionAction)

Regards

Aviral Nag


View solution in original post

2 Replies
aveeeeeee7en
Specialist III
Specialist III

Hi Elula

Try any 1 of the Expression as per your requirement:

1) sum({1<DateOnly= {"<=$(=vYesterday) >=$(=v3days)"}, partner_id={'*'}-{'221','1019'}>} ImpressionAction)

2) Sum({<DateOnly= {">=$(=vYesterday)<=$(=v3days)"}, partner_id={'*'}-{'221','1019'} >} ImpressionAction)

Regards

Aviral Nag


Not applicable
Author

Hi Aviral,

Thank you, your suggestion worked!