Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering via input field with operators

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.

TP

3 Replies
shree909
Partner - Specialist II
Partner - Specialist II

Hi replace the expression value 6 with the variable

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

find the file as attached..

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

so easy:)

thanks a lot!

Tom P