Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
My Qv Dashboard Dimension Field Is EmpCode,EmpName,City,State and Expression Field in Amount,TotalQuantity,AvgAmount We Want To Find Those Employee Which Amount Is Greater Than Given Input Box Please Help.......
Attach an "Select in Filed" Action to the onChange trigger of the variable you´re using into your inputbox
Write like
Let vMaxAmt = 0 and from input box pass the value to the variable
Dimension:-
EmpCode,EmpName,City,State
Expression:-
Sum(if(Amount > $(vMaxAmt) , Amount))