Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi replace the expression value 6 with the variable
=sum(aggr(if(sum(hodnota)>operand,sum(hodnota),0), barva))
find the file as attached..
Create a variable vOp as =znamenko&operand and change your chart expression to =sum(aggr(if(sum(hodnota)$(vOp),sum(hodnota),0), barva))
so easy:)
thanks a lot!
Tom P