topic Calculated Dimensions / Variables in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimensions-Variables/m-p/458270#M559934 <HTML><HEAD></HEAD><BODY><P>I have a calculated dimension in an object that groups our clients into roughly 10 buckets. I also have 4 or 5 variables for each of these buckets that I want to assign. The calculated dimension changes infrequently, the variables more often...</P><P></P><P>Example (buckets are the calculated dimension, rev/exp are the variables):</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rev Increase&nbsp;&nbsp;&nbsp; Expense Increase</P><P>Bucket 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.02</P><P>Bucket 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.15</P><P>Bucket 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.07&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.01</P><P></P><P></P><P>From above I want to be able to assign the variables to the calculated dimension in an as automated way as possible.</P></BODY></HTML> Tue, 14 May 2013 15:42:28 GMT zagzebski 2013-05-14T15:42:28Z Calculated Dimensions / Variables https://community.qlik.com/t5/QlikView/Calculated-Dimensions-Variables/m-p/458270#M559934 <HTML><HEAD></HEAD><BODY><P>I have a calculated dimension in an object that groups our clients into roughly 10 buckets. I also have 4 or 5 variables for each of these buckets that I want to assign. The calculated dimension changes infrequently, the variables more often...</P><P></P><P>Example (buckets are the calculated dimension, rev/exp are the variables):</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rev Increase&nbsp;&nbsp;&nbsp; Expense Increase</P><P>Bucket 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.02</P><P>Bucket 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.15</P><P>Bucket 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.07&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.01</P><P></P><P></P><P>From above I want to be able to assign the variables to the calculated dimension in an as automated way as possible.</P></BODY></HTML> Tue, 14 May 2013 15:42:28 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimensions-Variables/m-p/458270#M559934 zagzebski 2013-05-14T15:42:28Z