topic Re: firstsortedvalue and AGGR in QlikView

firstsortedvalue and AGGR

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

Hi All,

I have the following 2 expression

exp1 Aggr(Sum([Entryheader.provide-integral]), [Entryheader.noncust-name],Entryheader.Zone)

exp 2 FirstSortedValue([Entryheader.provide-integral],[Entryheader.item-number])

both work as stand alone expression for testing but I need to combine the 2 and I am having issues

Any help is appreciated.

rustyfishbones — Fri, 28 Sep 2018 13:38:44 GMT

I am using the expression in a Pivot Table

sasiparupudi1 — Fri, 28 Sep 2018 14:15:39 GMT

Did you try?

Aggr(FirstSortedValue([Entryheader.provide-integral],[Entryheader.item-number]),Entryheader.Zone)

rustyfishbones — Fri, 28 Sep 2018 14:22:12 GMT

That does not work, thanks.

raman_rastogi — Fri, 28 Sep 2018 14:27:32 GMT

May Like this

FirstSortedValue([Entryheader.provide-integral],-Aggr(Sum([Entryheader.item-number]),[Entryheader.noncust-name],Entryheader.Zone))

rustyfishbones — Fri, 28 Sep 2018 14:31:26 GMT

Thanks, but not does not work for me either.

vishsaggi — Fri, 28 Sep 2018 15:19:13 GMT

May be try this?

Sum(Aggr(FirstSortedValue([Entryheader.provide-integral],[Entryheader.item-number]), [Entryheader.noncust-name],Entryheader.Zone))