topic Re: AGGR, with + <= joins in set anylsis in App Development

AGGR, with + <= joins in set anylsis

joeybird — Thu, 23 Aug 2018 12:56:35 GMT

how do you complete a AGGR calculation with a complex set analysis . this is what I have and it don't work

Sum(Aggr(Sum({$<RankNo =

{"=rank(Only({$<OrderWeekFlag = {1}, [DeliveryDate] = {'>=$(=vMinDeliveryWeek)'}>

<OrderWeekFlag = {1}>}RankNo)), [Department]))

$(=sum(aggr(sum({$< [DeliveryDate]= {'>=$(=vMinDeliveryWeek)'} , OrderWeekFlag = {1} >}

"},OrderWeekFlag = {1} >}

[HasOrder]), [Department]))

/ Sum(AGGR(sum({$< OrderWeekFlag = {1} >}[HasOrder]), [Department]))

any ideas please

Kind Regards

Re: AGGR, with + <= joins in set anylsis

BalaBhaskar_Qlik — Thu, 23 Aug 2018 14:18:43 GMT

Try to change your expression like this:

=Sum({<[Buying Group]={"=rank(sum({<Date={'>=$(=Date(monthstart(max(Date),-5)))<=$(=Date(max(Date)))'}, Year, Month, [Month Year]>}[Exclusive Amount]))<21"}, Year=,Month=, [Month Year]=,

Date={">=$(=Date(monthstart(max(Date),-5)))<=$(=Date(max(Date)))"}

>} [Exclusive Amount])

https://community.qlikview.com/thread/63151

Re: AGGR, with + <= joins in set anylsis

joeybird — Fri, 24 Aug 2018 07:52:15 GMT

I have tried to alter the above with no joy

just looking at the first part of the set analysis

Sum({$<[Department] =

{"=rank(sum({$<OrderWeekFlag = {1}, [DeliveryDate] = {'>=$(=vMinDeliveryWeek)'}>

<OrderWeekFlag = {1}>}RankNo)), [Department]))

$(=sum(aggr(sum({$< [DeliveryDate]= {'>=$(=vMinDeliveryWeek)'} , OrderWeekFlag = {1} >}

"},OrderWeekFlag = {1} >}

[HasOrder]), [Department]))

I get just 0

any ideas please?

Re: AGGR, with + <= joins in set anylsis

BalaBhaskar_Qlik — Fri, 24 Aug 2018 09:02:23 GMT

Can you please let me know, your requirement from the above expression?

Re: AGGR, with + <= joins in set anylsis

BalaBhaskar_Qlik — Fri, 24 Aug 2018 09:03:04 GMT

Can you provide the script or Screenshots of Objects, then it's better get an idea on it.

Re: AGGR, with + <= joins in set anylsis

joeybird — Fri, 31 Aug 2018 15:32:00 GMT

is there a way of making the rank dynamic please. as I think that is the issue

I need to use

aggr(class(rank(sum

but I don't know where to slot it in the above expression..i have tried with no joy

please help