topic Re: AGGR across table qliksense in QlikView

AGGR across table qliksense expression using + <=

joeybird — Mon, 26 Jan 2026 18:19:17 GMT

this following expression works fine as a normal KPI.

Sum({$<RankNo =

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

<OrderWeekFlag = {1}>}RankNo))

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

"},OrderWeekFlag = {1} >}

[HasOrder])

I want it to work in a table , that has dimension of 'Department'

I understand I need to use something like SUM(AGGR(SUM(Cost), [DEPARTMENT]))

but how use SUM(AGGR(SUM ... in the expression below

Sum({$<RankNo =

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

<OrderWeekFlag = {1}>}RankNo))

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

"},OrderWeekFlag = {1} >}

[HasOrder])

I have tried with no joy

update:

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]))

this is how close I have now got with no joy

Qlik does not see to aggregate sums well across dimensions

please help

Re: AGGR across table qliksense

michaelsikora — Thu, 16 Aug 2018 12:51:18 GMT

Joanna,

Maybe try to load the two set analysis as variable. You can do this by going to variable overview in the settings tab. Then you click add variable. So you will have something like the following:

Sum({$<

Variable1

Variable2>}

[HasOrder])

Re: AGGR across table qliksense

joeybird — Thu, 16 Aug 2018 13:11:43 GMT

I don't understand sorry?

please help

Kind Regards

Re: AGGR across table qliksense

michaelsikora — Thu, 16 Aug 2018 14:27:15 GMT

Hi,

Go to settings and variable overview. Add variable for each set analysis you have. Then you can use the two variables in your set analysis. You cannot have set analysis within set analysis unless you create it as variable.

Re: AGGR across table qliksense

joeybird — Wed, 22 Aug 2018 14:10:22 GMT

here is an updated expression

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]))

please help