topic Re: Filter based on a column in QlikView

Filter based on a column

Fri, 29 Nov 2013 11:47:10 GMT

I have some raw data and I want to make filter button so when I click the button it only shows rows from the raw data where that column is greater than 0.

How to do this filter?

Re: Filter based on a column

sujeetsingh — Fri, 29 Nov 2013 12:09:50 GMT

You can do it fromUI and even from Script to I have done it in both way in following sample /

The one calculated in UI expression is named as UIDerived and the one which is coming from script is named as FromScript

Re: Filter based on a column

MayilVahanan — Fri, 29 Nov 2013 12:45:16 GMT

PFA

Re: Filter based on a column

Fri, 29 Nov 2013 14:14:16 GMT

Your example is almost perfect. It highlights the rows, but I want to hide all the other rows that are not highlighted.

This is not a filter, is just highlighting so can you help me on how to fix this?

Re: Filter based on a column

Fri, 29 Nov 2013 14:15:24 GMT

I tried your QVW and it didn't work. Also the code is too much for an example.

Maybe you can provide me a small example like Mayil?

Thanks,

Miguel

Re: Filter based on a column

MayilVahanan — Fri, 29 Nov 2013 14:21:19 GMT

For hide the excluded, you can try like this

in listbox properties -> General -> check Hide Excluded option

Re: Filter based on a column

Fri, 29 Nov 2013 14:29:47 GMT

But that leaves a blank row there....

Re: Filter based on a column

Fri, 29 Nov 2013 15:30:15 GMT

The correct answer attached.