Filter based on a column

[#1]

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?

[sujeetsingh]

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

[MayilVahanan]

Hi

PFA

[#4]

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?

[#5]

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

[MayilVahanan]

Hi

For hide the excluded, you can try like this

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

[#7]

But that leaves a blank row there....

[#8]

The correct answer attached.