topic Re: Using alternate states in Dimensions in QlikView https://community.qlik.com/t5/QlikView/Using-alternate-states-in-Dimensions/m-p/348727#M574736 <HTML><HEAD></HEAD><BODY><P>did you get a soultion for this? i have a similar problem. </P></BODY></HTML> Thu, 27 Sep 2012 11:35:42 GMT Anonymous 2012-09-27T11:35:42Z Using alternate states in Dimensions https://community.qlik.com/t5/QlikView/Using-alternate-states-in-Dimensions/m-p/348726#M574735 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>How can you use alternate states in dimensions? </P><P>In a scatter plot i have 2 dimensions A and B, where B is an alternate state of A. How can i use an alternate state of A as a dimension in a chart?</P><P></P><P>Thanks in advance,</P><P>Regards</P></BODY></HTML> Tue, 12 Jun 2012 11:33:44 GMT https://community.qlik.com/t5/QlikView/Using-alternate-states-in-Dimensions/m-p/348726#M574735 2012-06-12T11:33:44Z Re: Using alternate states in Dimensions https://community.qlik.com/t5/QlikView/Using-alternate-states-in-Dimensions/m-p/348727#M574736 <HTML><HEAD></HEAD><BODY><P>did you get a soultion for this? i have a similar problem. </P></BODY></HTML> Thu, 27 Sep 2012 11:35:42 GMT https://community.qlik.com/t5/QlikView/Using-alternate-states-in-Dimensions/m-p/348727#M574736 Anonymous 2012-09-27T11:35:42Z Re: Using alternate states in Dimensions https://community.qlik.com/t5/QlikView/Using-alternate-states-in-Dimensions/m-p/348728#M574737 <HTML><HEAD></HEAD><BODY><P>Nop. I had to change the database model. Try creating a copy of the table.</P></BODY></HTML> Thu, 27 Sep 2012 11:38:53 GMT https://community.qlik.com/t5/QlikView/Using-alternate-states-in-Dimensions/m-p/348728#M574737 2012-09-27T11:38:53Z Re: Using alternate states in Dimensions https://community.qlik.com/t5/QlikView/Using-alternate-states-in-Dimensions/m-p/348729#M574738 <HTML><HEAD></HEAD><BODY><P>I got mine to work using the following:</P><P></P><P>=Aggr(Max({$&lt;POSDate=P({[Alt Calendar]})&gt;}POSDate),POSDate)</P><P></P><P>POSDate is my dimension, but it needed to be limited by my alternate state (Alt Calendar).</P></BODY></HTML> Wed, 11 Sep 2013 18:30:17 GMT https://community.qlik.com/t5/QlikView/Using-alternate-states-in-Dimensions/m-p/348729#M574738 2013-09-11T18:30:17Z