Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bmensing
Contributor III
Contributor III

Listbox and Aggr Function

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 

6 Replies
sunny_talwar

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

vinieme12
Champion III
Champion III

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!!

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

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

vinieme12
Champion III
Champion III

oh yes, correct

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
bmensing
Contributor III
Contributor III
Author

the Expression of the variable is as follows

Sum({<

        Customer.Region = {"Asia"}

}>

Revenue

bmensing
Contributor III
Contributor III
Author

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() */