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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
stonecold111
Creator III
Creator III

straight table filter by button

hi Qliks

I have expression in straight table

which have values   'true'   'false'

i want to create button, when clicking on it the expression should only show

rows that contain value     'true'

how can i do that

17 Replies
stonecold111
Creator III
Creator III
Author

i created an expession based on if condition

if(field>20  and filed<100, true, false)

this is expression

now filter this expression for only true values using button in a straight table

prieper
Master II
Master II

you may place yr calculation/condition into a calculated listbox

see attached.

Peter

stonecold111
Creator III
Creator III
Author

its not field it is expression

stonecold111
Creator III
Creator III
Author

yes this is what i did already. here you have 3 o's and 2 -1's

but if u have all zeroes it won't show -1 in list box

but i want -1 also i list

because my user will select true check box or false check box

so it show all the time

Anil_Babu_Samineni

Check whether this will helps you? Enclose attached

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
stonecold111
Creator III
Creator III
Author

yes this is what i want but where is attachment anil babu

stonecold111
Creator III
Creator III
Author

no attachement

stonecold111
Creator III
Creator III
Author

stalwar1‌ help me on this