topic Re: Monthwise Data Needed in QlikView https://community.qlik.com/t5/QlikView/Monthwise-Data-Needed/m-p/319743#M1189764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please have a look at script and pivot table expressions in my attached app.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Sat, 30 Jul 2011 13:28:51 GMT swuehl 2011-07-30T13:28:51Z Monthwise Data Needed https://community.qlik.com/t5/QlikView/Monthwise-Data-Needed/m-p/319742#M1189763 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Please check enclosed table showing Customer Name, Customer ID and Date wise data for number of pallets made/dispatched at/from our warehouse. Positive numbers showing pallet made at warehouse and negative numbers showing pallets dispatched to customer from our warehouse.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">I want below table in Qlikview.. Kindly provide me code for the same. Also, while loading I can see that date is automatically formated in numbers. </SPAN><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">How can I get Date instead of numbers while selecting fields in qlikview.</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 360px;"><TBODY><TR><TD class="xl70" height="21" style="text-align: center;" width="198"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Description</SPAN></TD><TD class="xl71" style="text-align: center; border-left: medium none;" width="46"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">TOTAL</SPAN></TD><TD class="xl71" style="text-align: center; border-left: medium none;" width="54"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">January</SPAN></TD><TD class="xl72" style="text-align: center; border-left: medium none;" width="62"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">February</SPAN></TD></TR><TR><TD class="xl67" height="20" style="text-align: center;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Total Pallets Made</SPAN></TD><TD class="xl68" style="text-align: center; border-left: medium none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">94</SPAN></TD><TD class="xl68" style="text-align: center; border-left: medium none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">71</SPAN></TD><TD class="xl69" style="text-align: center; border-left: medium none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">23</SPAN></TD></TR><TR><TD class="xl64" height="21" style="text-align: center; border-top: medium none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Total Pallets Dispatched</SPAN></TD><TD class="xl65" style="text-align: center; border-left: medium none; border-top: medium none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">88</SPAN></TD><TD class="xl65" style="text-align: center; border-left: medium none; border-top: medium none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">34</SPAN></TD><TD class="xl66" style="text-align: center; border-left: medium none; border-top: medium none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">41</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 30 Jul 2011 11:06:19 GMT https://community.qlik.com/t5/QlikView/Monthwise-Data-Needed/m-p/319742#M1189763 2011-07-30T11:06:19Z Re: Monthwise Data Needed https://community.qlik.com/t5/QlikView/Monthwise-Data-Needed/m-p/319743#M1189764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please have a look at script and pivot table expressions in my attached app.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Sat, 30 Jul 2011 13:28:51 GMT https://community.qlik.com/t5/QlikView/Monthwise-Data-Needed/m-p/319743#M1189764 swuehl 2011-07-30T13:28:51Z