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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LISTBOX FILTERING BASED ON RESULT

Hi everybody,

I have a probleme in my document : I load 3 columns with 2 values for each.

NameSalary
Alex500
Chang1400
Romain1500

I make a graph-table with an expression like that :

NameSalaryGroup
=Name=Salary=If(Salary>1000,'Group1',Group2)
Alex500Group1
Chang1000Group2
Romain1500Group2

I would like to make a listbox which present the two possible value which are generated by the "group column expression" (=If(Salary>1000,'Group1',Group2))

My user select Group1 on a list box and the table is refresh with only the Group1 value.

Thx a lot

Labels (1)
2 Replies
tresB
Champion III
Champion III

Put your formula: =If(Salary>1000,'Group1',Group2)    in the expression.

Untitled2.png

Not applicable
Author

Thx very much