topic How do I filter a straight table w/ expressions? in QlikView

How do I filter a straight table w/ expressions?

Wed, 25 Nov 2020 16:16:04 GMT

I have a field with the values 'Yes' or 'No'. How do I filter the table to only show 'Yes' values? Without creating a button or filter list.

What I've tried so far is to create a 'match' expression and then hide the null values. However the values converted to 0 or 1, and the 0 values wouldn't suppress.

The field name is: Rights/Options/Warrants

TIA.

Re: How do I filter a straight table w/ expressions?

Anonymous — Mon, 22 Aug 2016 12:47:59 GMT

Hi Ben,

Can you apply set analysis to one of the Expressions in your straight table:

{<[Rights/Options/Warrants]={'Yes'}>}

Charlie

Re: How do I filter a straight table w/ expressions?

marcus_sommer — Mon, 22 Aug 2016 13:11:17 GMT

You could use a condition within the dimension like:

if([Rights/Options/Warrants] = 'Yes', [Rights/Options/Warrants])

and hiding NULL within the dimension. Or you used as respectively within each expression a set analysis like:

sum({< {Rights/Options/Warrants] = {'Yes'}>} AnyValueField)

and hiding NULL within the presentation tab.

- Marcus

Re: How do I filter a straight table w/ expressions?

Anil_Babu_Samineni — Mon, 22 Aug 2016 13:22:22 GMT

Use this,

if(wildmatch(FieldName.,'Yes')>0

,FieldName

,'Others'

) as <New Field Name>