Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to do what if analysis...nd how to make charts
pls suggest
thanks
Have a look at below:
QlikView How To (or Tips & Tricks) Application by Lee Matthews
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.