what if analysis

abhaysingh — Tue, 21 Apr 2015 09:17:27 GMT

How to do what if analysis...nd how to make charts

pls suggest

thanks

Re: what if analysis

jpenuliar — Tue, 21 Apr 2015 09:18:04 GMT

Have a look at below:

QlikView How To (or Tips & Tricks) Application by Lee Matthews

buzzy996 — Tue, 21 Apr 2015 09:45:09 GMT

try this way,

1. create a variable "VariableForWhatIf"

2. create slider--- from New sheet objects

3. slect INput Style as slider from generalt ab of slider/calendar

4. select Variable(s) radio button as "VariableForWhatIf"

5. set Min Value as 0 and Max Value as 100 and click ok.

6. select Chart from New sheet objects,choose Bar

7. On bar cahrt:select ur Dimensions on dimension tab and expression on ur expression

8. go to expression tab and use ur varilabe "VariableForWhatIf" to multiply with any of ur expressions on ur expression tab.

exp: =sum(Sales)*VariableForWhatIf

9. try to move ur slider ,now u can see how it'w working as what-If-Analysis.