topic Qlik Sense - Date in App Development https://community.qlik.com/t5/App-Development/Qlik-Sense-Date/m-p/22129#M1483 <HTML><HEAD></HEAD><BODY><P>Hi Team, </P><P></P><P>I have a requirement </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="855"><TBODY><TR><TD class="xl65" height="19" width="119">OPERATOR</TD><TD class="xl65" style="border-left: none;" width="129">PSC</TD><TD class="xl65" style="border-left: none;" width="233">FIELD</TD><TD class="xl65" style="border-left: none;" width="87">31/10</TD><TD class="xl66" style="border-left: none;" width="87">1</TD><TD class="xl66" style="border-left: none;" width="113">2</TD><TD class="xl66" style="border-left: none;" width="87">3</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">EMEPMI</TD><TD class="xl67" style="border-top: none; border-left: none;">2008 PSC</TD><TD class="xl67" style="border-top: none; border-left: none;">Guntong-D/E</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.2</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">EMEPMI</TD><TD class="xl67" style="border-top: none; border-left: none;">2008 PSC</TD><TD class="xl67" style="border-top: none; border-left: none;">Palas-A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.6</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">EMEPMI</TD><TD class="xl67" style="border-top: none; border-left: none;">2008 PSC</TD><TD class="xl67" style="border-top: none; border-left: none;">Tabu-A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.5</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">EMEPMI</TD><TD class="xl67" style="border-top: none; border-left: none;">2008 PSC</TD><TD class="xl67" style="border-top: none; border-left: none;">Guntong-A/B/C/F</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">5.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9.8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9.8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9.8</TD></TR></TBODY></TABLE><P></P><P>The Dates here are mentioned as 1 , 2 , 3 till monthend. How to handle this situation ,&nbsp; Need your input on this. </P><P></P><P></P><P>Regards,</P><P>senthil&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 28 Mar 2018 07:43:32 GMT psenthilbtech 2018-03-28T07:43:32Z Qlik Sense - Date https://community.qlik.com/t5/App-Development/Qlik-Sense-Date/m-p/22129#M1483 <HTML><HEAD></HEAD><BODY><P>Hi Team, </P><P></P><P>I have a requirement </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="855"><TBODY><TR><TD class="xl65" height="19" width="119">OPERATOR</TD><TD class="xl65" style="border-left: none;" width="129">PSC</TD><TD class="xl65" style="border-left: none;" width="233">FIELD</TD><TD class="xl65" style="border-left: none;" width="87">31/10</TD><TD class="xl66" style="border-left: none;" width="87">1</TD><TD class="xl66" style="border-left: none;" width="113">2</TD><TD class="xl66" style="border-left: none;" width="87">3</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">EMEPMI</TD><TD class="xl67" style="border-top: none; border-left: none;">2008 PSC</TD><TD class="xl67" style="border-top: none; border-left: none;">Guntong-D/E</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3.2</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">EMEPMI</TD><TD class="xl67" style="border-top: none; border-left: none;">2008 PSC</TD><TD class="xl67" style="border-top: none; border-left: none;">Palas-A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.6</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">EMEPMI</TD><TD class="xl67" style="border-top: none; border-left: none;">2008 PSC</TD><TD class="xl67" style="border-top: none; border-left: none;">Tabu-A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2.5</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">EMEPMI</TD><TD class="xl67" style="border-top: none; border-left: none;">2008 PSC</TD><TD class="xl67" style="border-top: none; border-left: none;">Guntong-A/B/C/F</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">5.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9.8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9.8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9.8</TD></TR></TBODY></TABLE><P></P><P>The Dates here are mentioned as 1 , 2 , 3 till monthend. How to handle this situation ,&nbsp; Need your input on this. </P><P></P><P></P><P>Regards,</P><P>senthil&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 28 Mar 2018 07:43:32 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Date/m-p/22129#M1483 psenthilbtech 2018-03-28T07:43:32Z Re: Qlik Sense - Date https://community.qlik.com/t5/App-Development/Qlik-Sense-Date/m-p/22130#M1484 <HTML><HEAD></HEAD><BODY><P>You can use CrossTable !!</P><P>But what is meaning of 1,2,3??? Are they belongs to current month?</P></BODY></HTML> Wed, 28 Mar 2018 07:54:53 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Date/m-p/22130#M1484 MK_QSL 2018-03-28T07:54:53Z Re: Qlik Sense - Date https://community.qlik.com/t5/App-Development/Qlik-Sense-Date/m-p/22131#M1485 <HTML><HEAD></HEAD><BODY><P>That is the date </P><P></P><P>1 for 1/11/2017 (DD/MM/YYYY)</P><P>2 for 2/11/2017</P></BODY></HTML> Wed, 28 Mar 2018 08:01:25 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Date/m-p/22131#M1485 psenthilbtech 2018-03-28T08:01:25Z Re: Qlik Sense - Date https://community.qlik.com/t5/App-Development/Qlik-Sense-Date/m-p/22132#M1486 <HTML><HEAD></HEAD><BODY><P>Use CrossTable load.</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P></BODY></HTML> Wed, 28 Mar 2018 08:50:14 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Date/m-p/22132#M1486 MK_QSL 2018-03-28T08:50:14Z