topic Listbox and formula in pivot table in QlikView

Listbox and formula in pivot table

stark___ — Thu, 25 Oct 2012 13:23:28 GMT

Hello,

I need help.

I have two objects: listbox and pivot table. Is it possible if I select something in listbox, my expression in pivot table will be, for example, sum(sales)*10 and if I don't select anything in my listbox, my expression will be,for example, sum(sales)+10?

Thank you, Stark

Re: Listbox and formula in pivot table

MayilVahanan — Thu, 25 Oct 2012 13:34:34 GMT

Try like this

=if(Count(GetFieldSelections(FieldName))>0,Sum(Sales)*10,Sum(Sales)+10)

Re: Listbox and formula in pivot table

stark___ — Fri, 26 Oct 2012 08:44:32 GMT

Thank you, it works perfetct.