topic Re: Set Analysis Ignores 'Full Set' indicator when using intersections? in QlikView

Set Analysis Ignores 'Full Set' indicator when using intersections?

Fri, 05 Jun 2015 15:53:13 GMT

I'm having a problem with an expression using set analysis with intersections. It seems to ignore the '1' at the beginning of the set statement that should make it ignore any selections made. I tried putting a 1 at the beginning of each set statement, but the value still changes any time i make a selection. Here's an example of the syntax I'm trying to use:

Count({1<SF_DATE = {'>$(=date(v90DaysPast))'}>*1< SF_DATE = {">$(=min(CAMP_START_DT))=$(=min(PROMO_RESP_WINDOW))"}>*1<SALES_FUNNEL_PHASE = {'SALE'}>} UNIQUEID)

Maybe i'm just missing a character somewhere?

Re: Set Analysis Ignores 'Full Set' indicator when using intersections?

swuehl — Fri, 05 Jun 2015 16:01:35 GMT

Ashley,

your dollar sign expansions are probably affected by user selections, for example the min() functions.

You can add a set identifer {1} also to the min() function.

Variable v90DaysPast should also be checked.

Besides that, hard to help you without knowing your data, model, requirements...

Re: Set Analysis Ignores 'Full Set' indicator when using intersections?

Gysbert_Wassenaar — Fri, 05 Jun 2015 16:52:49 GMT

< SF_DATE = {">$(=min(CAMP_START_DT))=$(=min(PROMO_RESP_WINDOW))"}>

This doesn't look quite right. Is there a < character missing before the = character in front of $(=min(PROMO_RESP_WINDOW))? Or is PROMO_RESP_WINDOW a number of days that should be added to or subtracted from the date returned by min(CAMP_START_DT)?