Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
no update?
?????
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? PLEASE!!!!
no update?
Has anyone got any suggestions please?
Hi Blaze,
It's simply because the variable for your quantity slider is not included in your formula..