topic Re: Filter On Dimension Field using InputBox in QlikView

Filter On Dimension Field using InputBox

vijayit43 — Thu, 24 Apr 2014 14:52:52 GMT

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.......

Re: Filter On Dimension Field using InputBox

Clever_Anjos — Thu, 24 Apr 2014 14:55:40 GMT

Attach an "Select in Filed" Action to the onChange trigger of the variable you´re using into your inputbox

Re: Filter On Dimension Field using InputBox

its_anandrjs — Thu, 24 Apr 2014 14:59:36 GMT

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))