topic Re: Listbox and Aggr Function in QlikView

Listbox and Aggr Function

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

Good Day to everyone,

listbox shows the Dimension Customer, my pivottable shows the Revenue. The Revenue is stored in a variable, and all i want to do

is to show only customer with an Input in Revenue. And alternative, how does the Expression look like when the Revenue is not a variable, but a data field.

Best regards

Re: Listbox and Aggr Function

sunny_talwar — Fri, 29 Jul 2016 09:04:37 GMT

Would you be able to share more information (or ideally a sample) to show what you have and what are you trying to accomplish?

Re: Listbox and Aggr Function

vinieme12 — Fri, 29 Jul 2016 09:14:12 GMT

for your listbox use an expression as below

AGGR(

if(sum($(Revenue))>0,Customer)

, Customer)

For the second part , can you provide the variable expression for Revenue? the variable must be evaluating on a dimension!!

Re: Listbox and Aggr Function

sunny_talwar — Fri, 29 Jul 2016 09:20:19 GMT

Sum() without Aggr() as list box expression will work? I doubt, but have not tested this out

Re: Listbox and Aggr Function

vinieme12 — Fri, 29 Jul 2016 09:27:15 GMT

oh yes, correct

Re: Listbox and Aggr Function

bmensing — Fri, 29 Jul 2016 11:36:11 GMT

the Expression of the variable is as follows

Sum({<

Customer.Region = {"Asia"}

Revenue

Re: Listbox and Aggr Function

bmensing — Fri, 29 Jul 2016 11:56:15 GMT

i think it makes sense to post the whole Expression of the variable..

sum(

aggr(

if ( BB_SperrZuord.archiviert = '0',

Sum (

V_BelegKopf.BelegArt = {"U", "G"},

V_BelegKopf.AuftragsArt -= {"50"},

V_BelegKopf.LagerOrt -= {"1902", "1800"},

V_BelegKopf.Firma = {"100", "160", "170", "180"},

BB_SperrZuord.Sperrgrund -= {"996", "997", "998", "999"}

((V_BelegPos.Gesamtpreis + (V_BelegPos.Gesamtpreis * V_BelegKopf.proz_Zuschlag / 100) * V_BelegKopf.xc_Kurs))),

Sum (

V_BelegKopf.BelegArt = {"U", "G"},

V_BelegKopf.AuftragsArt -= {"50"},

V_BelegKopf.LagerOrt -= {"1902", "1800"},

V_BelegKopf.Firma = {"100", "160", "170", "180"}

((V_BelegPos.Gesamtpreis + (V_BelegPos.Gesamtpreis * V_BelegKopf.proz_Zuschlag / 100) * V_BelegKopf.xc_Kurs)))

) /* Ende if() */

,Kalender.Datum, V_BelegKopf.ReferenzNr, V_BelegPos.PositionsNr, V_BelegKopf.Firma

) /* Ende aggr() */

) /* Ende first sum() */