Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

what if analysis

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

pls suggest

thanks

2 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

Have a look at below:

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

 

http://community.qlik.com/docs/DOC-5486

buzzy996
Master II
Master II

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.