Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Valued Contributor III

Re: set analysis with exclusion

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


2 Replies
aveeeeeee7en
Valued Contributor III

Re: set analysis with exclusion

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

Re: set analysis with exclusion

Hi Aviral,

Thank you, your suggestion worked!

Community Browser