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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
vijayit43
Creator
Creator

Filter On Dimension Field using InputBox

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

2 Replies
Clever_Anjos
Employee
Employee

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

its_anandrjs
Champion III
Champion III

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