topic Re: how to make Aggr with set analysis in QlikView

how to make Aggr with set analysis

brijeshvma — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one Expression as say : Sum(Aggr(Visits,VisitFull))

and i am making one WTD Condtion in Calander Script :

If( Weekday(Date) <= Weekday(Today()-1), 1, 0) as IsInWTD ...

So i Currently i am putting Sum({<IsInWTD={1}>}Visits) .... But i want Aggr this Expression on VisitFull...

So i want to Use This Set Analysis : {<IsInWTD={1} In Sum(Aggr(Visits,VisitFull)) Aggre expression...

Kinldy Help me on this

Re: how to make Aggr with set analysis

MK_QSL — Wed, 30 Mar 2016 10:44:48 GMT

SUM( Aggr(Sum({<IsInWTD={1}>}Visits),VisitFull))

Re: how to make Aggr with set analysis

Chanty4u — Wed, 30 Mar 2016 10:46:14 GMT

try this

if(sum(aggr(sum({<IsInWTD={1}>}visits),visitfull))

sum(aggr(sum({<IsInWTD={1}>}visits),visitfull)

Re: how to make Aggr with set analysis

swuehl — Wed, 30 Mar 2016 10:51:20 GMT

Or even

SUM({<IsInWTD={1}>} Aggr(Sum({<IsInWTD={1}>}Visits),VisitFull))

Set Analysis in the Aggr function

Re: how to make Aggr with set analysis

ahmar811 — Wed, 30 Mar 2016 10:56:13 GMT

Brijesh Maurya‌

try this

expression

=Sum({<IsInWTD={1}>}Aggr(Visits,VisitFull))

hope this help you

Thanks & Regards

Ahmar Ansari

Re: how to make Aggr with set analysis

jonathandienst — Wed, 30 Mar 2016 11:07:16 GMT

What purpose does the Aggr() serve? In most cases, Sum(Aggr(Sum({.} F1), F2) is the same as Sum(F1) and much more expensive to calculate. If you are trying filter, then rather use something like:

Sum({<F2 = P(F2)>} F1)