topic Re: Converting dimensions to expression in QlikView https://community.qlik.com/t5/QlikView/Converting-dimensions-to-expression/m-p/510571#M1147897 <HTML><HEAD></HEAD><BODY><P>see attachedment</P></BODY></HTML> Tue, 23 Jul 2013 05:43:42 GMT 2013-07-23T05:43:42Z Converting dimensions to expression https://community.qlik.com/t5/QlikView/Converting-dimensions-to-expression/m-p/510569#M1147895 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 270px;"><TBODY><TR><TD class="xl63" height="17" width="115">Operator</TD><TD class="xl63" style="border-left: none;" width="60">Time</TD><TD class="xl62" width="95">IN OUT</TD></TR><TR><TD class="xl70" height="34" rowspan="2" style="border-top: none;">EFO</TD><TD class="xl67" style="border-top: none; border-left: none;">Apr 13</TD><TD class="xl64" style="border-top: none;">1000 times</TD></TR><TR><TD class="xl68" height="17" style="border-top: none; border-left: none;">Apr 12</TD><TD class="xl65" style="border-top: none;"><SPAN style="color: #ff0000;"><STRONG>2000 times</STRONG></SPAN></TD></TR><TR><TD class="xl70" height="35" rowspan="2" style="border-bottom: 1.0pt solid black; border-top: none;">GER</TD><TD class="xl67" style="border-top: none; border-left: none;">Apr 13</TD><TD class="xl64" style="border-top: none;">2500 times</TD></TR><TR><TD class="xl69" height="18" style="border-top: none; border-left: none;">Apr 12</TD><TD class="xl66" style="border-top: none;"><SPAN style="color: #ff0000;"><STRONG>7000<STRONG style="color: #ff0000;"> times</STRONG></STRONG></SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>Hello guys, is there any way i can do this Month On Month by removing the dimensions and filter with expressions?</P><P></P><P>It will somehow look like the table below,</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: rgb(102, 144, 188); text-align: center;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: center;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>IN OUT</STRONG></SPAN></TH></TR><TR><TD style="text-align: center;">Apr 13</TD><TD style="text-align: center;">1000 times</TD></TR><TR><TD style="text-align: center;">Apr 12</TD><TD style="text-align: center;"><STRONG style="color: #ff0000;">2000<STRONG style="color: #ff0000;"> times</STRONG></STRONG></TD></TR><TR><TD style="text-align: center;">Apr 13</TD><TD style="text-align: center;">2500 times</TD></TR><TR><TD style="text-align: center;">Apr 12</TD><TD style="text-align: center;"><STRONG style="color: #ff0000;">7000<STRONG style="color: #ff0000;"> times</STRONG></STRONG></TD></TR></TBODY></TABLE><P></P><P></P><P>Can anyone help? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Tue, 23 Jul 2013 02:02:03 GMT https://community.qlik.com/t5/QlikView/Converting-dimensions-to-expression/m-p/510569#M1147895 2013-07-23T02:02:03Z Re: Converting dimensions to expression https://community.qlik.com/t5/QlikView/Converting-dimensions-to-expression/m-p/510570#M1147896 <HTML><HEAD></HEAD><BODY><P>pfa</P></BODY></HTML> Tue, 23 Jul 2013 04:17:12 GMT https://community.qlik.com/t5/QlikView/Converting-dimensions-to-expression/m-p/510570#M1147896 Siva_Sankar 2013-07-23T04:17:12Z Re: Converting dimensions to expression https://community.qlik.com/t5/QlikView/Converting-dimensions-to-expression/m-p/510571#M1147897 <HTML><HEAD></HEAD><BODY><P>see attachedment</P></BODY></HTML> Tue, 23 Jul 2013 05:43:42 GMT https://community.qlik.com/t5/QlikView/Converting-dimensions-to-expression/m-p/510571#M1147897 2013-07-23T05:43:42Z