topic Indirect Set Analysis question in QlikView

Indirect Set Analysis question

Wed, 23 Apr 2014 08:34:49 GMT

Could someone please help me to understand why the first expression returns cumulative figures, whilst the second does not (only the exclusion parameter has been removed).

Count(DISTINCT{$<CCMonthID = {"<=$(=Max(CCMonthID))"},CCYear=,CCQuarter =,CCMonth = ,[CustomerID]=P({<[C delete label]={''}> + <DeleteMonthID = {">$(=Max(CCMonthID))"}>}),[ CustomerID]=E({<Addr={''}> * <[PostCode]={''}>})>}[ CustomerID])

Count(DISTINCT{$<CCMonthID = {"<=$(=Max(CCMonthID))"},CCYear=,CCQuarter =,CCMonth = ,[CustomerID]=P({<[C delete label]={''}> + <DeleteMonthID = {">$(=Max(CCMonthID))"}>})[ CustomerID])

Thank you.

Re: Indirect Set Analysis question

MK_QSL — Wed, 23 Apr 2014 08:38:14 GMT

Difficult to answer without looking your sample data.

Re: Indirect Set Analysis question

Wed, 23 Apr 2014 09:42:08 GMT

You may be sure, that set of rows in first expression is not less than in 2'nd expression, because E() forces rows with Addr and PostCode = ' '. Those rows are not present (because they are excluded) in 2'nd expression.

<DeleteMonthID = {">$(=Max(CCMonthID))"}>}),[ CustomerID]=E({<Addr={''}> * <[PostCode]={''}>})>

<DeleteMonthID = {">$(=Max(CCMonthID))"}>

regards

Darek