topic Re: Autogenerate Dimensions with Variables in QlikView https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064647#M464466 <HTML><HEAD></HEAD><BODY><P>I wrote a blog quite recently on a very similar topic which I think may help you:</P><P><A href="http://www.qliktastic.com/2016/01/23/synthetic-dimension-parameterised-variables/" title="http://www.qliktastic.com/2016/01/23/synthetic-dimension-parameterised-variables/">An Extreme Synthetic Dimension in QlikView</A></P></BODY></HTML> Wed, 20 Apr 2016 14:51:25 GMT gsbeaton 2016-04-20T14:51:25Z Autogenerate Dimensions with Variables https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064641#M464460 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I want to create a calculated Dimension based von variables in a Inpout Box. I don't load data in this QVW, only with variables, <SPAN class="short_text" lang="en">which can be specified manually.</SPAN></P><P></P><P>The calculated dimenson should be generated with this variables: vMin, vMax, vStep</P><P></P><P>e.g.</P><P></P><P>vMin=10000</P><P>vMax=25000</P><P>vStep=1000</P><P></P><TABLE border="1" class="jiveBorder" height="213" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 294px; height: 215px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Dimension</STRONG></TH></TR><TR><TD style="padding: 2px;">10000</TD></TR><TR><TD style="padding: 2px;">11000</TD></TR><TR><TD style="padding: 2px;">12000</TD></TR><TR><TD style="padding: 2px;">13000</TD></TR><TR><TD style="padding: 2px;">...</TD></TR><TR><TD style="padding: 2px;"><P>25000</P></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 20 Apr 2016 10:00:19 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064641#M464460 tiklabaq 2016-04-20T10:00:19Z Re: Autogenerate Dimensions with Variables https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064642#M464461 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">and of course I should be able to work with these values in the expression.</SPAN></P><P><SPAN lang="en"></SPAN></P><P><SPAN lang="en">For example:</SPAN></P><P><SPAN lang="en"></SPAN></P><P><SPAN lang="en"></SPAN></P><P><SPAN lang="en"><SPAN class="short_text" lang="en">hourly wage (variable field in input box) * dimension</SPAN></SPAN></P></BODY></HTML> Wed, 20 Apr 2016 12:06:57 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064642#M464461 tiklabaq 2016-04-20T12:06:57Z Re: Autogenerate Dimensions with Variables https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064643#M464462 <HTML><HEAD></HEAD><BODY><P>May be use ValueLoop:</P><P></P><P><STRONG>ValueLoop($(vMin), $(vMax), $(vStep))</STRONG></P></BODY></HTML> Wed, 20 Apr 2016 12:26:46 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064643#M464462 sunny_talwar 2016-04-20T12:26:46Z Re: Autogenerate Dimensions with Variables https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064644#M464463 <HTML><HEAD></HEAD><BODY><P>thx, it works. and how can I use this values in the expression?</P></BODY></HTML> Wed, 20 Apr 2016 12:29:56 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064644#M464463 tiklabaq 2016-04-20T12:29:56Z Re: Autogenerate Dimensions with Variables https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064645#M464464 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122170_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P></P><P>vVal1 :10</P><P>vVal2:30</P><P>vVal3:5</P></BODY></HTML> Wed, 20 Apr 2016 12:52:04 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064645#M464464 Anonymous 2016-04-20T12:52:04Z Re: Autogenerate Dimensions with Variables https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064646#M464465 <HTML><HEAD></HEAD><BODY><P>ok I got it <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>You can use it in a dimension and if you use the same valueloop in the calculation you get the one value of this dimension line.</P></BODY></HTML> Wed, 20 Apr 2016 14:26:05 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064646#M464465 tiklabaq 2016-04-20T14:26:05Z Re: Autogenerate Dimensions with Variables https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064647#M464466 <HTML><HEAD></HEAD><BODY><P>I wrote a blog quite recently on a very similar topic which I think may help you:</P><P><A href="http://www.qliktastic.com/2016/01/23/synthetic-dimension-parameterised-variables/" title="http://www.qliktastic.com/2016/01/23/synthetic-dimension-parameterised-variables/">An Extreme Synthetic Dimension in QlikView</A></P></BODY></HTML> Wed, 20 Apr 2016 14:51:25 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064647#M464466 gsbeaton 2016-04-20T14:51:25Z Re: Autogenerate Dimensions with Variables https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064648#M464467 <HTML><HEAD></HEAD><BODY><P>What is the expression you are intending to use?</P></BODY></HTML> Wed, 20 Apr 2016 15:08:52 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Dimensions-with-Variables/m-p/1064648#M464467 sunny_talwar 2016-04-20T15:08:52Z