topic Re: Filtering via input field with operators in QlikView

Filtering via input field with operators

Tue, 29 Jan 2013 20:05:51 GMT

Hi,

I Need help with this task.

I have source data, which i need to aggr in QV and select according input field within operator (less than, greater than...).

If I use this =sum(aggr(if(sum(hodnota)>6,sum(hodnota),0), barva)) in expression, it is working, but i need change >6 by values from input field (operator and value).

Can somebody help me?:)

Thanks.

Re: Filtering via input field with operators

shree909 — Tue, 29 Jan 2013 20:16:01 GMT

Hi replace the expression value 6 with the variable

=sum(aggr(if(sum(hodnota)>operand,sum(hodnota),0), barva))

find the file as attached..

Re: Filtering via input field with operators

Gysbert_Wassenaar — Tue, 29 Jan 2013 20:17:56 GMT

Create a variable vOp as =znamenko&operand and change your chart expression to =sum(aggr(if(sum(hodnota)$(vOp),sum(hodnota),0), barva))

Re: Filtering via input field with operators

Wed, 30 Jan 2013 07:10:41 GMT

so easy:)

thanks a lot!

Tom P