topic Re: calculated dimesnion in QlikView https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113309#M367900 <HTML><HEAD></HEAD><BODY><P>sorting on month wise</P></BODY></HTML> Thu, 07 Jul 2016 17:35:03 GMT manoranjan_d 2016-07-07T17:35:03Z calculated dimesnion https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113306#M367897 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to do calculated dimension(line chart) for the month field where it should get the latest year of the months only..</P><P></P><P>can you one help for this</P><P></P><P></P><P>example</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="font-style: inherit;" width="64">year</TD><TD class="xl63" style="border-left: none; font-style: inherit;" width="64">month</TD><TD class="xl63" style="border-left: none; font-style: inherit;" width="64">dept</TD><TD class="xl63" style="border-left: none; font-style: inherit;" width="64">AMT</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2016</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">JAN</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">CSE</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">100</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2016</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">FEB</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">IT</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">200</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2016</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">MAR</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">EEE</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">300</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2016</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">APR</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">CSE</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">400</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2015</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">JAN</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">CSE</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">500</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2015</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">FEB</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">IT</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">600</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2015</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">MAR</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">EEE</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">700</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2015</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">APR</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">CSE</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">800</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2015</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">MAY</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">EEE</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">900</TD></TR><TR style="font-weight: inherit; font-style: inherit;"><TD class="xl63" height="20" style="border-top: none; font-style: inherit;" width="64">2015</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">JUNE</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">CSE</TD><TD class="xl63" style="border-top: none; border-left: none; font-style: inherit;" width="64">1000</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 07 Jul 2016 17:20:06 GMT https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113306#M367897 manoranjan_d 2016-07-07T17:20:06Z Re: calculated dimesnion https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113307#M367898 <HTML><HEAD></HEAD><BODY><P>May be this as the calculated dimension:</P><P><STRONG>=If(year = Year(Today()), year_month)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/130550_Capture.PNG" style="height: 210px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Thu, 07 Jul 2016 17:26:54 GMT https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113307#M367898 sunny_talwar 2016-07-07T17:26:54Z Re: calculated dimesnion https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113308#M367899 <HTML><HEAD></HEAD><BODY><P>how to sort these?</P></BODY></HTML> Thu, 07 Jul 2016 17:33:32 GMT https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113308#M367899 manoranjan_d 2016-07-07T17:33:32Z Re: calculated dimesnion https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113309#M367900 <HTML><HEAD></HEAD><BODY><P>sorting on month wise</P></BODY></HTML> Thu, 07 Jul 2016 17:35:03 GMT https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113309#M367900 manoranjan_d 2016-07-07T17:35:03Z Re: calculated dimesnion https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113310#M367901 <HTML><HEAD></HEAD><BODY><P>In Sort tab, Numeric Value ascending. See screen shot:</P><P></P><P><IMG __jive_id="130540" alt="Sort.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/130540_Sort.jpg" style="height: 388px; width: 620px;" /></P><P><IMG alt="Sort_2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/130553_Sort_2.jpg" style="height: 255px; width: 620px;" /></P></BODY></HTML> Thu, 07 Jul 2016 17:37:10 GMT https://community.qlik.com/t5/QlikView/calculated-dimesnion/m-p/1113310#M367901 trdandamudi 2016-07-07T17:37:10Z