topic Re: Calculation for each dimension in chart using variables in QlikView https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057027#M943626 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Check this,</P><P></P><P><IMG alt="Input Variable Chart.PNG" class="jive-image image-1" src="/legacyfs/online/111147_Input Variable Chart.PNG" style="height: 304px; width: 620px;" /></P><P></P><P></P><P>From your data,</P><P>-&gt;Create a Input Box and Define a <STRONG>variable</STRONG>.</P><P></P><P>-&gt;In Chart -&gt; Expression -&gt; <STRONG>Sum(Value)*Variable.</STRONG></P><P></P><P>Then by passing the value in input box varies your result.</P><P></P><P>Hope this Helps,</P><P>PFA,</P><P>Regards,</P><P>Hirish</P></BODY></HTML> Sat, 09 Jan 2016 12:35:54 GMT HirisH_V7 2016-01-09T12:35:54Z Calculation for each dimension in chart using variables https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057025#M943624 <HTML><HEAD></HEAD><BODY><P>Hello, I have a list of towns and a cash value:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Location</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH></TR><TR><TD style="padding: 2px;">Town 1</TD><TD style="padding: 2px;">6654</TD></TR><TR><TD style="padding: 2px;">Town 2</TD><TD style="padding: 2px;">1213</TD></TR><TR><TD style="padding: 2px;">Town 3</TD><TD style="padding: 2px;">9988</TD></TR><TR><TD style="padding: 2px;">Town 4</TD><TD style="padding: 2px;">4458</TD></TR></TBODY></TABLE><P></P><P>I need to provide an input table with a number variable for each town. Then using the number input by the user for each town, calculate Variable*Value=Metric in a bar graph.</P></BODY></HTML> Sat, 09 Jan 2016 05:10:10 GMT https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057025#M943624 2016-01-09T05:10:10Z Re: Calculation for each dimension in chart using variables https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057026#M943625 <HTML><HEAD></HEAD><BODY><P>just an idea in the attachment</P><P></P><P>you can edit the InputVar field in the tablebox at the top</P></BODY></HTML> Sat, 09 Jan 2016 11:43:47 GMT https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057026#M943625 maxgro 2016-01-09T11:43:47Z Re: Calculation for each dimension in chart using variables https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057027#M943626 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Check this,</P><P></P><P><IMG alt="Input Variable Chart.PNG" class="jive-image image-1" src="/legacyfs/online/111147_Input Variable Chart.PNG" style="height: 304px; width: 620px;" /></P><P></P><P></P><P>From your data,</P><P>-&gt;Create a Input Box and Define a <STRONG>variable</STRONG>.</P><P></P><P>-&gt;In Chart -&gt; Expression -&gt; <STRONG>Sum(Value)*Variable.</STRONG></P><P></P><P>Then by passing the value in input box varies your result.</P><P></P><P>Hope this Helps,</P><P>PFA,</P><P>Regards,</P><P>Hirish</P></BODY></HTML> Sat, 09 Jan 2016 12:35:54 GMT https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057027#M943626 HirisH_V7 2016-01-09T12:35:54Z Re: Calculation for each dimension in chart using variables https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057028#M943627 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can take any no of Input box, in this example i have taken only two input box.</P><P>Please find attached Qlikview Doc.</P></BODY></HTML> Sat, 09 Jan 2016 13:10:20 GMT https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057028#M943627 rajeshforqlikvi 2016-01-09T13:10:20Z Re: Calculation for each dimension in chart using variables https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057029#M943628 <HTML><HEAD></HEAD><BODY><P>Maxgro, thanks - now what if I have 4 more values that need the same treatment? Can we make more than 1 INPUTFIELD in a qvw?</P></BODY></HTML> Sat, 09 Jan 2016 13:14:16 GMT https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057029#M943628 2016-01-09T13:14:16Z Re: Calculation for each dimension in chart using variables https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057030#M943629 <HTML><HEAD></HEAD><BODY><P>Just to show what i need a little better, I'm loading Town and Value from the data source. The users will input the "Input Variable". The chart expression will use the "Formula" to produce the chart below. Is INPUTFIELD still a viable solution? Can this even be done?</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111154_Untitled.png" style="height: auto;" /></P></BODY></HTML> Sat, 09 Jan 2016 14:23:17 GMT https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057030#M943629 2016-01-09T14:23:17Z Re: Calculation for each dimension in chart using variables https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057031#M943630 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Like this,</P><P></P><P>Adding new input field column as other,</P><P></P><P></P><P>PFA</P><P>HTH,</P><P>Hirish</P></BODY></HTML> Sat, 09 Jan 2016 14:23:48 GMT https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057031#M943630 HirisH_V7 2016-01-09T14:23:48Z Re: Calculation for each dimension in chart using variables https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057032#M943631 <HTML><HEAD></HEAD><BODY><P>Perfect, thank you.</P></BODY></HTML> Sat, 09 Jan 2016 15:43:51 GMT https://community.qlik.com/t5/QlikView/Calculation-for-each-dimension-in-chart-using-variables/m-p/1057032#M943631 2016-01-09T15:43:51Z