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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
Partner - Champion III
Partner - Champion III

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