topic Formula explanation please!!! in QlikView

Formula explanation please!!!

Mon, 21 Nov 2011 03:01:06 GMT

Hi folks,

Can anyone kindly explain to me how the below formula works?

Max(Total Aggr(Count( Distinct {<[Case Owner]={*}>}%CaseId), [Case Owner]))

Especially I want to clearly understand this part {<[Case Owner]={*}>}%CaseId)

Thanks in advance!!!

Formula explanation please!!!

Anonymous — Mon, 21 Nov 2011 03:42:20 GMT

Part {<[Case Owner]={*}>}%CaseId) returns %CaseId which has "Case Owner".
So,
(Count( Distinct {<[Case Owner]={*}>}%CaseId) - counts number of cases which have case owner.
Next, aggr(...,"Case Owner") - the count above is grouped by case owner.
And,
max() - returns the max number of cases per case owner.
"total" means ignore dimensions in the chart where this expression is used - can't guess more.

Hope it helps...

Formula explanation please!!!

Mon, 21 Nov 2011 03:47:46 GMT

So, I can assume that <[Case Owner]={*}> means every case owner in the list.

Could this one be used instead??

Max(Total Aggr(Count([%CaseId]), [Case Owner]))

Thanks!!

Formula explanation please!!!

rohit214 — Mon, 21 Nov 2011 04:30:39 GMT

{<[Case Owner]={*}>}%CaseId)

it means all value of Case owner field

thanks

rohit

Formula explanation please!!!

Anonymous — Mon, 21 Nov 2011 10:56:36 GMT

Max(Total Aggr(Count([%CaseId]), [Case Owner])) is close but not exactly the same. The * "selects" all values - that is it "excludes" Case Owner that is not assiciated with any case. But it all depends of the overall data model and the data itself - it may or may not be the same..