Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
rustyfishbones
Honored Contributor II

firstsortedvalue and AGGR

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.

6 Replies
rustyfishbones
Honored Contributor II

Re: firstsortedvalue and AGGR

I am using the expression in a Pivot Table

sasiparupudi1
Honored Contributor III

Re: firstsortedvalue and AGGR

Did you try?

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

rustyfishbones
Honored Contributor II

Re: firstsortedvalue and AGGR

That does not work, thanks.

Partner
Partner

Re: firstsortedvalue and AGGR

May Like this

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

rustyfishbones
Honored Contributor II

Re: firstsortedvalue and AGGR

Thanks, but not does not work for me either.

vishsaggi
Esteemed Contributor III

Re: firstsortedvalue and AGGR

May be try this?

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