topic Re: straight table filter by button in QlikView

straight table filter by button

stonecold111 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: straight table filter by button

Anil_Babu_Samineni — Wed, 10 May 2017 10:40:23 GMT

Please provide sample data

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 10:49:49 GMT

true

false

true

false

this is my expression values

when i click on button straight table get filtered for values "true" and it should hide false values

what sample data u need

Re: straight table filter by button

Anil_Babu_Samineni — Wed, 10 May 2017 11:00:18 GMT

Is this you want to see?

For True and same False

Re: straight table filter by button

RonaldDoes — Wed, 10 May 2017 11:02:26 GMT

You might as well use a listbox then, right?

Re: straight table filter by button

Anil_Babu_Samineni — Wed, 10 May 2017 11:03:40 GMT

True, He may have some depth in his requirement.

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 11:09:56 GMT

i clearly mentioned that is expression not field

i know this

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 11:11:17 GMT

i created an expession based on if condition

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

something like this

Re: straight table filter by button

Anil_Babu_Samineni — Wed, 10 May 2017 11:11:49 GMT

How we know whether which expression you make for Report? Atleast provide more information

Qlik Community Tip: How to Get Answers to Your Post

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 11:15:07 GMT

yes i can use list box using expression

but when no single true values is there it is showing only false check box

and how to do it with button

whatever it maybe something that looks good for my user

give suggestions

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 11:16:23 GMT

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

Re: straight table filter by button

prieper — Wed, 10 May 2017 11:16:31 GMT

you may place yr calculation/condition into a calculated listbox

see attached.

Peter

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 11:17:07 GMT

its not field it is expression

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 11:32:46 GMT

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

Re: straight table filter by button

Anil_Babu_Samineni — Wed, 10 May 2017 11:43:28 GMT

Check whether this will helps you? Enclose attached

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 11:46:17 GMT

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

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 11:57:06 GMT

no attachement

Re: straight table filter by button

stonecold111 — Wed, 10 May 2017 12:22:00 GMT

stalwar1‌ help me on this