topic Re: How can Apply 2 Sliders (Sale and Inventory Sliders ) to a pivot table? in QlikView

How can Apply 2 Sliders (Sale and Inventory Sliders ) to a pivot table?

Thu, 31 Oct 2013 14:02:44 GMT

How can Apply 2 Sliders (Sale and Inventory Sliders ) to a pivot table?

For Example : "Sales between 100 and 200" & "Inventory between 10 and 20" ( dynamic filter)

Gysbert_Wassenaar — Thu, 31 Oct 2013 15:17:22 GMT

See attached qvw.

Thu, 31 Oct 2013 16:31:45 GMT

Hi Gysbert ,

Thanks for your reply.

but i need Only filter Articles and Areas that "Sales between 100 and 200" AND "Inventory between 10 and 20" ( dynamic filter).

no OR condition.

Gysbert_Wassenaar — Fri, 01 Nov 2013 07:00:18 GMT

Then put both conditions in both expressions instead of each expression having only one condition each.

Fri, 01 Nov 2013 07:43:51 GMT

is it correct in both expressions?

expressions1:

if( sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY) >= $(vMin) and sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY) <= $(vMax) and

sum(DYNAMIC_EXCHANGE.SALES) >= $(vMin_sale) and

sum(DYNAMIC_EXCHANGE.SALES) <= $(vMax_sale)

,sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY))

expressions2:

if( sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY) >= $(vMin) and sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY) <= $(vMax) and

sum(DYNAMIC_EXCHANGE.SALES) >= $(vMin_sale) and

sum(DYNAMIC_EXCHANGE.SALES) <= $(vMax_sale)

,sum(DYNAMIC_EXCHANGE.SALES))

Gysbert_Wassenaar — Fri, 01 Nov 2013 07:49:56 GMT

That looks correct.