topic Sliders in QlikView

Sliders

Fri, 23 Jul 2010 10:47:09 GMT

I got 3 sliders containing sales cost and quantity.

If i raise the sales or the cost it affects the GP outcome 100% but whenever i raise the quantity slider it doesnt affect the cost or GP outcome.

Can anyone PLEASE PLEASE PLEASE PLEASE HELP!!!!

Sliders

Fri, 23 Jul 2010 10:55:50 GMT

Please provice more details.

Best would be an example QVW!

Sliders

Fri, 23 Jul 2010 11:11:44 GMT

sliders are as follows

1.Sales= vSales2

2.Cost=vCost2

3.Quantity=vQuantity2

got a table underneath that displays the amounts. when the values are set to 0 they are right

e.g.

And when i move the sales or cost slider it affects the GP

e.g

But if i only move the quantity slider, then the GP as well as the Cost doesnt change

e.g.

Sliders

Fri, 23 Jul 2010 11:17:25 GMT

Formula in the What if Table.

1.Sales= $(vSales) * (1 + vSales2/100) where $(vSales) = Sum(Sales)

2.Cost=($(vCost) * (1 + vCost2/100)) Where $(vCost)=Sum(cost)

3.GP=$(vSales) * (1 + vSales2/100) - $(vCost) * (1 + vCost2/100)

4.Quantity=$(vQuantity) * (1 + vQuantity2/100)

5.GP%=$(vSales) * (1 + vSales2/100) - $(vCost) * (1 + vCost2/100)

Sliders

Fri, 23 Jul 2010 11:41:26 GMT

cnt seem to figure it out?

Sliders

Fri, 23 Jul 2010 11:56:27 GMT

This might seem a bit obvious, so maybe I'm missing something that I should be seeing:

Your formula for Cost and your formula for GP does not have any reference to Quantity, so I'm struggling to know how those values would change when you slide quantity. I would imagine that your quantity column changes, but unless you create some reference to vQty in the GP & Cost formulas, it simply wont change them.

Let me know if I've missed something glaringly obvious!

Sliders

Fri, 23 Jul 2010 11:59:28 GMT

Hi Nigel.

U are correct but i cnt seem to put quantty n either of them coz the data come out wierd.

Got any suggestions?

Sliders

Fri, 23 Jul 2010 13:49:37 GMT

anyone got any ideas?

Sliders

Fri, 23 Jul 2010 13:49:41 GMT

I'm assuming that quantity has an impact on sales, but that the value Sales is already resolved in the load script by multiplying a price by a quantity, and that the same goes for cost.

If the above is the case then you cannot execute a What If on quantity, because you have no idea what price to multiply the quantity by in order to come with a new value for both cost and sales.

If your original expression was something like:

=Sum(Price * Quantity)

and

=Sum(UnitCost * Quantity)

Then you could introduce quantity into the what if scenario by executing a modification formula on both aspects of the above.

Other than that, you would need to execute a whatif using an average price, for example:

( Original Sales/Original Quantity ) * WhatIfQuantity.

Final answer really depends on what you want to achieve.

Sliders

Fri, 23 Jul 2010 13:55:01 GMT

Hi Nigel

Yea I gave up on that. Thanks for helping anyways.