topic Re: Filter data in a table in QlikView

Filter data in a table

Mon, 14 May 2012 09:44:24 GMT

Hi,

I have some problem regarding filter data in a table:

look at the Period Revenue column:

Publisher	Period Revenue
AppBank (Rubicon Project)	$2,364
Ace Top Media 2	$1,668
TLV Media	$2,876
Boxore.com	$2,137
Adnetwork.net Premium Ads	$2,006

Lets say i want to show in the table only when the sum is above 2300$. So i enter in a Input Box this amount and i expect to see in the table:

Publisher	Period Revenue $
AppBank (Rubicon Project)	$2,364
TLV Media	$2,876

How can i accomplish that?

Thanks,

Guy

Re: Filter data in a table

deepakk — Mon, 14 May 2012 09:51:11 GMT

Try out the attached application.

Deepak

Filter data in a table

Mon, 14 May 2012 12:33:49 GMT

Thanks a lot, it is working now. just to clear it up:

1. if there is more than 1 column in the table, you should enter the expression (see bellow) in each of them (so all the row would disapear in case the condition hasn't met)

2. i changed your condition in the expression to be:

if(vtest< Sum(Amount), Sum(Amount))

Thanks agian!

Guy