topic Problem with designing dimensions in QlikView https://community.qlik.com/t5/QlikView/Problem-with-designing-dimensions/m-p/926444#M972111 <HTML><HEAD></HEAD><BODY><P>I have a table named OC which contained OCCode , start date , end date&nbsp; .</P><P></P><P>I need to use this dismension two times as filter&nbsp; :</P><UL><LI>First I need to add OC and in order to get the following result :</LI></UL><P>when I choose OCC111 as <SPAN style="font-size: 13.3333px;">OCCode,&nbsp;&nbsp; I should get CA total for all OCbetween the start date and the end date for <SPAN style="font-size: 13.3333px;">OCC111 .</SPAN></SPAN></P><UL><LI>Another filter for the dimension OC when I choose <SPAN style="font-size: 13.3333px;">OCC111 as </SPAN><SPAN style="font-size: 13.3333px;">OCCode <SPAN style="font-size: 13.3333px;">I should get CA total only for <SPAN style="font-size: 13.3333px;">OCC111 <SPAN style="font-size: 13.3333px;"> between the start date and the end&nbsp; </SPAN></SPAN></SPAN></SPAN></LI></UL><P></P><P></P><P>How to design it in qlikview ? This is what I tried :</P><P></P><P><IMG __jive_id="98540" alt="Sans titre.png" class="jive-image image-1" src="/legacyfs/online/98540_Sans titre.png" style="height: 366px; width: 620px;" /></P></BODY></HTML> Thu, 10 Sep 2015 12:35:58 GMT Anonymous 2015-09-10T12:35:58Z Problem with designing dimensions https://community.qlik.com/t5/QlikView/Problem-with-designing-dimensions/m-p/926444#M972111 <HTML><HEAD></HEAD><BODY><P>I have a table named OC which contained OCCode , start date , end date&nbsp; .</P><P></P><P>I need to use this dismension two times as filter&nbsp; :</P><UL><LI>First I need to add OC and in order to get the following result :</LI></UL><P>when I choose OCC111 as <SPAN style="font-size: 13.3333px;">OCCode,&nbsp;&nbsp; I should get CA total for all OCbetween the start date and the end date for <SPAN style="font-size: 13.3333px;">OCC111 .</SPAN></SPAN></P><UL><LI>Another filter for the dimension OC when I choose <SPAN style="font-size: 13.3333px;">OCC111 as </SPAN><SPAN style="font-size: 13.3333px;">OCCode <SPAN style="font-size: 13.3333px;">I should get CA total only for <SPAN style="font-size: 13.3333px;">OCC111 <SPAN style="font-size: 13.3333px;"> between the start date and the end&nbsp; </SPAN></SPAN></SPAN></SPAN></LI></UL><P></P><P></P><P>How to design it in qlikview ? This is what I tried :</P><P></P><P><IMG __jive_id="98540" alt="Sans titre.png" class="jive-image image-1" src="/legacyfs/online/98540_Sans titre.png" style="height: 366px; width: 620px;" /></P></BODY></HTML> Thu, 10 Sep 2015 12:35:58 GMT https://community.qlik.com/t5/QlikView/Problem-with-designing-dimensions/m-p/926444#M972111 Anonymous 2015-09-10T12:35:58Z