topic I need staright table in QlikView https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129363#M902285 <HTML><HEAD></HEAD><BODY><P><SPAN style="text-decoration: underline;">Hi </SPAN></P><P>I have date field coming from June 2016&nbsp; having incidents and problems&nbsp; raised for example</P><P>NO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TYPE&nbsp;&nbsp;&nbsp; date raised&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Summary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Group</P><P>IN211&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02-02-2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UAT-PRD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Admin</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24-01-2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN219&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12-03-2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRD_UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DeV</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02-02-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN211&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV</P><P>IN211&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13-07-2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UAT-PRD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV</P><P>IN211&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV</P><P>Hi</P><P>I need staright table&nbsp; with dimensions as date,NO and Summary</P><P>In Dimension(OpenDate) i need the date coming from July2016</P><P>Can anyone help me?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mshailaja 2020-11-25T16:16:04Z I need staright table https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129363#M902285 <HTML><HEAD></HEAD><BODY><P><SPAN style="text-decoration: underline;">Hi </SPAN></P><P>I have date field coming from June 2016&nbsp; having incidents and problems&nbsp; raised for example</P><P>NO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TYPE&nbsp;&nbsp;&nbsp; date raised&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Summary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Group</P><P>IN211&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02-02-2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UAT-PRD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Admin</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24-01-2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN219&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12-03-2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRD_UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DeV</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02-02-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN211&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV</P><P>IN211&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13-07-2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UAT-PRD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV</P><P>IN211&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN</P><P>IN345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17-07-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV-UAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEV</P><P>Hi</P><P>I need staright table&nbsp; with dimensions as date,NO and Summary</P><P>In Dimension(OpenDate) i need the date coming from July2016</P><P>Can anyone help me?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129363#M902285 mshailaja 2020-11-25T16:16:04Z Re: I need staright table https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129364#M902286 <HTML><HEAD></HEAD><BODY><P>And what exactly is your problem?</P><P>What did you try so far?</P><P>Could you share us your .QVW file so we do not have to do everything?</P></BODY></HTML> Mon, 11 Jul 2016 11:19:57 GMT https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129364#M902286 oknotsen 2016-07-11T11:19:57Z Re: I need staright table https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129365#M902287 <HTML><HEAD></HEAD><BODY><P>Hi Shailaja,</P><P></P><P>What is your Exact requirement? <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> What is your Expected output?<SPAN style="font-size: 13.3333px;">In your source no "</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">OpenDate" Field.</SPAN></SPAN></P><P></P><P></P><P>Regards</P></BODY></HTML> Mon, 11 Jul 2016 11:26:14 GMT https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129365#M902287 qlikview979 2016-07-11T11:26:14Z Re: I need staright table https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129366#M902288 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P>LOAD *, MonthName([date raised]) as MonthName INLINE [</P><P>NO,TYPE,date raised,Summary,&nbsp;&nbsp; Group</P><P>IN211,I,02-02-2015,&nbsp;&nbsp; UAT-PRD, Admin</P><P>IN345,P,&nbsp; 24-01-2014, DEV-UAT, ADMIN</P><P>IN219,I,12-03-2013,PRD_UAT, DeV</P><P>IN345,P,&nbsp; 02-02-2016, DEV-UAT,ADMIN</P><P>IN211,I,22-07-2016, DEV-UAT, ADMIN</P><P>IN345,P,11-07-2016,&nbsp; DEV-UAT, DEV</P><P>IN211,I,13-07-2015,&nbsp; DEV-UAT, ADMIN</P><P>IN345,P, 14-07-2016,UAT-PRD, DEV</P><P>IN211,I,16-07-2016,DEV-UAT, ADMIN</P><P>IN345,P,17-07-2016,DEV-UAT, DEV</P><P>];</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>date raised</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>NO</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Summary</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>=Only({&lt;MonthName = {'Jul 2016'}&gt;}[date raised])</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11-07-2016</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">IN345</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DEV-UAT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11-07-2016</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">14-07-2016</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">IN345</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">UAT-PRD</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">14-07-2016</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">16-07-2016</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">IN211</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DEV-UAT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">16-07-2016</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">17-07-2016</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">IN345</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DEV-UAT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">17-07-2016</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">22-07-2016</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">IN211</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DEV-UAT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">22-07-2016</SPAN></TD></TR></TBODY></TABLE><P></P><P>Exp: =Only({&lt;MonthName = {'$(=MonthName(Today()))'}&gt;}[date raised])</P></BODY></HTML> Mon, 11 Jul 2016 11:28:54 GMT https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129366#M902288 MayilVahanan 2016-07-11T11:28:54Z Re: I need staright table https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129367#M902289 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>May be help full&nbsp; this</P><P></P><P>Dimension:-<SPAN style="font-size: 13.3333px;">NO,<SPAN style="font-size: 13.3333px;">date raised,<SPAN style="font-size: 13.3333px;">Summary</SPAN></SPAN></SPAN></P><P></P><P>Expression:- Only({&lt;MONTH = {'Jul-2016'}&gt;}[date raised])</P><P></P><P>T1:</P><P>LOAD * INLINE [</P><P>NO,TYPE,date raised,Summary,&nbsp;&nbsp; Group</P><P>IN211,I,02-02-2015,&nbsp;&nbsp; UAT-PRD, Admin</P><P>IN345,P,&nbsp; 24-01-2014, DEV-UAT, ADMIN</P><P>IN219,I,12-03-2013,PRD_UAT, DeV</P><P>IN345,P,&nbsp; 02-02-2016, DEV-UAT,ADMIN</P><P>IN211,I,22-07-2016, DEV-UAT, ADMIN</P><P>IN345,P,11-07-2016,&nbsp; DEV-UAT, DEV</P><P>IN211,I,13-07-2015,&nbsp; DEV-UAT, ADMIN</P><P>IN345,P, 14-07-2016,UAT-PRD, DEV</P><P>IN211,I,16-07-2016,DEV-UAT, ADMIN</P><P>IN345,P,17-07-2016,DEV-UAT, DEV</P><P>];</P><P>NoConcatenate</P><P>T2:</P><P>load </P><P>NO,&nbsp; </P><P>TYPE,</P><P>Date(Date#([date raised],'DD-MM-YYYY'),'MMM-YYYY') as MONTH ,</P><P>[date raised],</P><P>Summary,</P><P>Group</P><P>Resident T1;</P><P>DROP Table T1;</P></BODY></HTML> Mon, 11 Jul 2016 11:51:26 GMT https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129367#M902289 qlikview979 2016-07-11T11:51:26Z Re: I need staright table https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129368#M902290 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>the data from the date filed&nbsp; and also in GMT Time and data is very huge,</P><P>so i dnt want to do in inline load </P></BODY></HTML> Mon, 11 Jul 2016 12:08:09 GMT https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129368#M902290 mshailaja 2016-07-11T12:08:09Z Re: I need staright table https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129369#M902291 <HTML><HEAD></HEAD><BODY><P>Actually i need incidents(NO) and problems(NO)&nbsp; with seperate straight tablesfrom the month of june 2016 and&nbsp; the date field coming from june 2016 , i need master calender associated with date raised field, i want also&nbsp; dateraised Incident no and dateraised problem no&nbsp; as columns , How? any one please help </P></BODY></HTML> Mon, 11 Jul 2016 12:42:49 GMT https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129369#M902291 mshailaja 2016-07-11T12:42:49Z Re: I need staright table https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129370#M902292 <HTML><HEAD></HEAD><BODY><P>Hi , I need previous month data</P><P>and also i need master calender starting from june2016 associated with the dateraised</P><P>Please help me</P></BODY></HTML> Tue, 12 Jul 2016 04:14:01 GMT https://community.qlik.com/t5/QlikView/I-need-staright-table/m-p/1129370#M902292 mshailaja 2016-07-12T04:14:01Z