topic Re: Create a What if Analysis with only variables in QlikView https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976246#M467491 <HTML><HEAD></HEAD><BODY><P>I want the expression value for each field to be different and be a result of selected values of sliders.</P></BODY></HTML> Wed, 11 Nov 2015 15:19:19 GMT 2015-11-11T15:19:19Z Create a What if Analysis with only variables https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976243#M467488 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have a kind of unique request. I would like to make a basic what if analysis using only variables. I have no data loaded and only variables defined with sliders with min, max and step size values. I would like to create charts that compare the values calculated by two sets of sliders. Basically it would have 2 dimensions item 1 and item 2 with expressions one calculated with one set of sliders and the other with the other set. Basically dimension 1 values would be slider 1 *slider 2 and dimension 2 would be slider 3 * slider 4.</P><P></P><P>Is there a way to do this and if so how?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 11 Nov 2015 15:14:51 GMT https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976243#M467488 2015-11-11T15:14:51Z Re: Create a What if Analysis with only variables https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976244#M467489 <HTML><HEAD></HEAD><BODY><P>Do you have two dimensions or 1 dimensions with two fields in it (Item1 and Item 2)?</P></BODY></HTML> Wed, 11 Nov 2015 15:17:04 GMT https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976244#M467489 sunny_talwar 2015-11-11T15:17:04Z Re: Create a What if Analysis with only variables https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976245#M467490 <HTML><HEAD></HEAD><BODY><P>Sorry one dimension with 2 fields</P></BODY></HTML> Wed, 11 Nov 2015 15:18:18 GMT https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976245#M467490 2015-11-11T15:18:18Z Re: Create a What if Analysis with only variables https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976246#M467491 <HTML><HEAD></HEAD><BODY><P>I want the expression value for each field to be different and be a result of selected values of sliders.</P></BODY></HTML> Wed, 11 Nov 2015 15:19:19 GMT https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976246#M467491 2015-11-11T15:19:19Z Re: Create a What if Analysis with only variables https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976247#M467492 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG __jive_id="105179" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105179_Capture.PNG" style="height: 325px; width: 620px;" /></P><P></P><P>Expression: <STRONG>=If(Dimension = 'Item1', vVar1 * vVar2, vVar3*vVar4)</STRONG></P></BODY></HTML> Wed, 11 Nov 2015 15:23:07 GMT https://community.qlik.com/t5/QlikView/Create-a-What-if-Analysis-with-only-variables/m-p/976247#M467492 sunny_talwar 2015-11-11T15:23:07Z