topic Re: Before Month value ? in QlikView https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910782#M316236 <HTML><HEAD></HEAD><BODY><P>Yes but not working.</P></BODY></HTML> Wed, 05 Aug 2015 08:04:26 GMT selcukcadir 2015-08-05T08:04:26Z Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910775#M316229 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>should be : Before month value &gt; current month value ?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Thanks in advance</SPAN></P><P></P><P><IMG alt="Ekran Alıntısı.PNG" class="jive-image image-1" src="/legacyfs/online/94972_Ekran Alıntısı.PNG" style="height: 319px; width: 620px;" /></P></BODY></HTML> Tue, 04 Aug 2015 20:41:28 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910775#M316229 selcukcadir 2015-08-04T20:41:28Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910776#M316230 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>=Before(YourExpressionForValueHere)</P></BODY></HTML> Tue, 04 Aug 2015 20:46:12 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910776#M316230 sunny_talwar 2015-08-04T20:46:12Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910777#M316231 <HTML><HEAD></HEAD><BODY><P>Before(value)</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I've tried. did not work. </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><IMG alt="Ekran Alıntısı2.PNG" class="jive-image image-1" src="/legacyfs/online/94979_Ekran Alıntısı2.PNG" style="height: 312px; width: 620px;" /><BR /></SPAN></P></BODY></HTML> Tue, 04 Aug 2015 20:58:34 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910777#M316231 selcukcadir 2015-08-04T20:58:34Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910778#M316232 <HTML><HEAD></HEAD><BODY><P>Try using Above and Below.</P></BODY></HTML> Tue, 04 Aug 2015 21:05:02 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910778#M316232 prabhu0505 2015-08-04T21:05:02Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910779#M316233 <HTML><HEAD></HEAD><BODY><P>thanks but <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">did not work.</SPAN></P></BODY></HTML> Tue, 04 Aug 2015 21:18:50 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910779#M316233 selcukcadir 2015-08-04T21:18:50Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910780#M316234 <HTML><HEAD></HEAD><BODY><P>is anyone to reply </P></BODY></HTML> Wed, 05 Aug 2015 07:45:49 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910780#M316234 selcukcadir 2015-08-05T07:45:49Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910781#M316235 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You tried it on Set analysis expresion?</P><P></P><P>Regards</P></BODY></HTML> Wed, 05 Aug 2015 07:58:22 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910781#M316235 sorrakis01 2015-08-05T07:58:22Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910782#M316236 <HTML><HEAD></HEAD><BODY><P>Yes but not working.</P></BODY></HTML> Wed, 05 Aug 2015 08:04:26 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910782#M316236 selcukcadir 2015-08-05T08:04:26Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910783#M316237 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you upload an example?</P><P></P><P>Regards</P></BODY></HTML> Wed, 05 Aug 2015 08:06:32 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910783#M316237 sorrakis01 2015-08-05T08:06:32Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910784#M316238 <HTML><HEAD></HEAD><BODY><P>added to example</P></BODY></HTML> Wed, 05 Aug 2015 08:40:46 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910784#M316238 selcukcadir 2015-08-05T08:40:46Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910785#M316239 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the problem is Dimension YAK. In this case Before() doesn't work because Rows of dimension is always 1.</P><P>If You remove Dimension YAK&nbsp; then Before() works.</P><P>Regards</P></BODY></HTML> Wed, 05 Aug 2015 08:53:08 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910785#M316239 antoniotiman 2015-08-05T08:53:08Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910786#M316240 <HTML><HEAD></HEAD><BODY><P>Is there another solution?</P></BODY></HTML> Wed, 05 Aug 2015 11:45:01 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910786#M316240 selcukcadir 2015-08-05T11:45:01Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910787#M316241 <HTML><HEAD></HEAD><BODY><P>As far as I know, I'm afraid no.</P><P>However, try with Dimension&nbsp; MonthName&amp;' '&amp;YAK</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Wed, 05 Aug 2015 11:54:17 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910787#M316241 antoniotiman 2015-08-05T11:54:17Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910788#M316242 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Is there another solution?</SPAN></P></BODY></HTML> Wed, 05 Aug 2015 12:59:58 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910788#M316242 selcukcadir 2015-08-05T12:59:58Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910789#M316243 <HTML><HEAD></HEAD><BODY><P>Possibly you can do this from script.</P></BODY></HTML> Wed, 05 Aug 2015 13:06:22 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910789#M316243 Kushal_Chawda 2015-08-05T13:06:22Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910790#M316244 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can do this by changing your script, can you attach sample data and the script you are using.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 06 Aug 2015 02:51:53 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910790#M316244 jagan 2015-08-06T02:51:53Z Re: Before Month value ? https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910791#M316245 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">Thanks for your time </SPAN><SPAN style="font-size: 13.3333330154419px;">Jagan,</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">,</SPAN></P><P></P><P>You can help in this regard.</P><P></P><P>Added file qvw and qvd.</P></BODY></HTML> Thu, 06 Aug 2015 05:18:36 GMT https://community.qlik.com/t5/QlikView/Before-Month-value/m-p/910791#M316245 selcukcadir 2015-08-06T05:18:36Z