topic Re: Two same dim + AS in QlikView https://community.qlik.com/t5/QlikView/Two-same-dim-AS/m-p/655191#M1058804 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can u pls share the sample app?</P><P></P><P>Thanks !!</P></BODY></HTML> Sat, 04 Oct 2014 20:04:07 GMT 2014-10-04T20:04:07Z Two same dim + AS https://community.qlik.com/t5/QlikView/Two-same-dim-AS/m-p/655189#M1058802 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Trying to make pivot table using two dimentions by X and by Y, but want to use same field in basic and alter state.</P><P>Basic state is simple, i just add dimention.</P><P>Alter state is: =AGGR(ONLY({AS1} MyDimention),MyDimention)</P><P>but when i select something at basic state it limits AS1 too, because it used at AGGR without alter state condition.</P><P></P><P>how can i make second dimention not limited by basic state selections?</P></BODY></HTML> Fri, 03 Oct 2014 14:07:48 GMT https://community.qlik.com/t5/QlikView/Two-same-dim-AS/m-p/655189#M1058802 2014-10-03T14:07:48Z Re: Two same dim + AS https://community.qlik.com/t5/QlikView/Two-same-dim-AS/m-p/655190#M1058803 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>The problem could be in the expression.</P></BODY></HTML> Sat, 04 Oct 2014 19:11:45 GMT https://community.qlik.com/t5/QlikView/Two-same-dim-AS/m-p/655190#M1058803 whiteline 2014-10-04T19:11:45Z Re: Two same dim + AS https://community.qlik.com/t5/QlikView/Two-same-dim-AS/m-p/655191#M1058804 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can u pls share the sample app?</P><P></P><P>Thanks !!</P></BODY></HTML> Sat, 04 Oct 2014 20:04:07 GMT https://community.qlik.com/t5/QlikView/Two-same-dim-AS/m-p/655191#M1058804 2014-10-04T20:04:07Z