AGGR, with + <= joins in set anylsis

[joeybird]

Hi

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

[BalaBhaskar_Qlik]

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

[joeybird]

Hi

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?

[BalaBhaskar_Qlik]

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

[BalaBhaskar_Qlik]

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

[joeybird]

Hi

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