topic set analysis with exclusion in QlikView

set analysis with exclusion

Sun, 02 Mar 2014 09:41:33 GMT

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!

Re: set analysis with exclusion

aveeeeeee7en — Sun, 02 Mar 2014 10:03:44 GMT

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

Re: set analysis with exclusion

Sun, 02 Mar 2014 10:50:55 GMT

Hi Aviral,

Thank you, your suggestion worked!