Putting a Filter in Listbox

Anonymous — Thu, 13 Aug 2015 14:10:44 GMT

Hi ,

Need Help!

I am trying to put filter in a listbox for Values > 0 as 'Excess' and Values <0 as 'Short' excluding all values equal to zero present in record.

when trying to do so I am getting some values equal to zero in Short as well as Excess at record level when a selection made for either Short or Excess.

Aggr(if((sum({< YEAR_R = {$(vPrevYear)}, MONTH_R= {$(vPrevMonth)} >}FINAL_READ)- Sum(INITL_READ))>0,'Excess','Short')),CON_REF)

Above Expression didn't worked for me , So I created another expression shown below by putting three selection in a filter viz. Excess , Short, and Zero , Still I am getting some values equal to zero in 'Short' & 'Excess' at record level.

Aggr(if((sum({< YEAR_R = {$(vPrevYear)}, MONTH_R= {$(vPrevMonth)} >}FINAL_READ)- Sum(INITL_READ))>0,'Excess',if((sum({< YEAR_R = {$(vPrevYear)}, MONTH_R= {$(vPrevMonth)} >}FINAL_READ)- Sum(INITL_READ))<0,'Short','Zero')),CON_REF)

Thanks in Advance.

Re: Putting a Filter in Listbox

MarcoWedel — Thu, 13 Aug 2015 21:49:48 GMT

‌please post sample data.

thanks

regards

Marco

topic Re: Putting a Filter in Listbox in QlikView

Putting a Filter in Listbox

Re: Putting a Filter in Listbox