topic Re: Value filters in List Box in QlikView

Value filters in List Box

anuradhaa — Thu, 02 May 2013 04:03:40 GMT

Hi,

I have created a list box and i need to filter values in it.

My list box is patrons and i have included the expression "=Money (sum( BILL_AMT) )"

in my list box.

Here Patron is one table and BILL_AMT in another table

But i need to show the patrons that have "=Money (sum( BILL_AMT) )>0" values.

So Pls help me to solw this problem.

Thanks

Re: Value filters in List Box

Fri, 03 May 2013 13:39:08 GMT

Hi anu,

try within the listbox an expression similar to this:

=if(aggr(sum(BILL_AMT), Patron) >0, Patron)

Regards

Roland

Re: Value filters in List Box

anuradhaa — Fri, 03 May 2013 15:36:04 GMT

Hi,

Thanks, This works for me. but still have a problem.

Now it will not show the sum( BILL_AMT) =0 value in the list box. But it display the text of the Patron name in the list box without that value. please help me to remove that text values also.

Thanks

Re: Value filters in List Box

Sat, 04 May 2013 15:14:06 GMT

Hi again,

take a look at attached example, expression of second listbox --> Is this what you want ?

HtH

Roland

Re: Value filters in List Box

anuradhaa — Mon, 06 May 2013 12:05:14 GMT

Hi Roland,

Yes the aggr function solve my issue.

Thanks