Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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