Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What if...?

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?

25 Replies
Not applicable
Author

no update?

Not applicable
Author

?????

Not applicable
Author

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!!!!



Not applicable
Author

no update?

Not applicable
Author

Has anyone got any suggestions please?

Not applicable
Author

Hi Blaze,

It's simply because the variable for your quantity slider is not included in your formula..