topic Re: Aggregation help in QlikView

Aggregation help

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

Hi all,

I have another aggregation problem..

in the attached QVW i have 2 straight tables..

The top one is a summary by customer and the bottom one is a breakdown by customer, item and period.

The PVI expression in the bottom chart gives the correct number. I am trying to get the same number in the PVI expression of the top chart but i am struggling to get it working.

Can anyone help please?

Re: Aggregation help

tresB — Wed, 04 Jul 2018 12:41:12 GMT

Sum( {<Period={"<=$(=GetFieldSelections(Period))"}>} Aggr(

(sum({<Period={"<=$(=GetFieldSelections(Period))"}>}[Standard Cost])

sum({<Period={"<=$(=GetFieldSelections(Period))"}>}[Latest Cost]))

sum({<Period={"<=$(=GetFieldSelections(Period))"}>}[Sales Volume])

,[Standard Cost],Period,Item,[Customer Name]

))

Re: Aggregation help

hopkinsc — Wed, 04 Jul 2018 12:53:52 GMT

thanks very much!