topic BUTTON in QlikView

BUTTON

Thu, 15 Nov 2012 14:29:00 GMT

I want to create a button which will give TOTAL qty sold > 140 for below table.

Once I click that button, only those Fruit will appear along with total Qty sold.

Fruit	Qty Sold	Customer
Apple	100	Cust001
Banana	50	Cust001
Orange	150	Cust002
Apple	75	Cust003
Grapes	80	Cust003
Apple	120	Cust005

for above table, final result on clicking that buttion should be

Fruit	Qty Sold
Apple	295
Orange	150

Re: BUTTON

Anonymous — Thu, 15 Nov 2012 15:03:35 GMT

Hi,

You can use Dimension Limits combined with a variable. Keep in mind that negative quantity numbers, even if you switch off filtering ($(i) = 0 ) won't be shown in this setup. But does the trick for what you have in mind here I believe.

Regards, Sander

Re: BUTTON

MayilVahanan — Thu, 15 Nov 2012 15:35:44 GMT

PFA

Re: BUTTON

Thu, 15 Nov 2012 15:56:54 GMT

Hi Mayil,

It's working... Thanks