What if...?

[#1]

Hi all

Im working on a qlikview model but a customer asked me to create a what if analysis using a slider object and a table containing x,y,z

any ideas how to go about doing that?

[#2]

no updates?

[#3]

this is what happens. In the slider, i set it to 0 and everything goes like this....

As appose from before i use the slider like this... .

[#4]

Hi Blaze,

Seems like there's something wrong on your formula. Try to check the formula for What-if Sales. Based from the image that you attached, the Sales value becomes 0 when the slider is in "0". You might forgot to put "1" on the formula:

sum (SALES) * ( 1 + v_Sales/100)

- Lester

[#5]

no there s a 1 in the formula buddy . Any other suggestions?

If i dont move the slider then nothing changes but as soon as i move it, then the whole document goes bonkerz

[#6]

Hmmm.. can you post a screen shot of your slider's properties and a charts expression tab? If possible..

[suniljain · Accepted solution]

Pls Check attached Doc.

It will Help You.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8182.What-If-analysis.doc:550:0]

[#8]

Hi,

please check the slider, did you connect to Variable with single mode?

[#9]

Yea i did but its still not working

[#10]

Worked like a charm. Thanks so much

[#11]

i got the whole thing working but now i need to add a slider contaning quantity. Ive put in the slider and it works and ive put it in the table along with sales, gp etc but whenever i move the quantity slider, the gp result and the cost does not change. there is a problem with the formulas but i cnt figure it out.

Formulas are:

sum(Cost) * (1 + vCost2/100) for What if Cost

and sum (Sales) * (1 + vSales2/100) - sum (Cost) * (1 + vCost2/100) for What if GP

Any help?

Thanks in advance