topic Simple: How to show/present specific month? in QlikView https://community.qlik.com/t5/QlikView/Simple-How-to-show-present-specific-month/m-p/161716#M35502 <HTML><HEAD></HEAD><BODY><P>Hi Guys,<BR /><BR />I have data base called "Employment Date" it take from SQL database.<BR />I already load the "Employment Date" on script.<BR />By using:<BR />Date("Employment Date")<BR />Month("Employment Date")</P><P>Question is how do I able to show/present total every specific month by column in expression.<BR />It should like this below:</P><P>Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec</P><P>- JAN will showing total all employment at first month(JAN).<BR />- FEB will showing total all employment at first month(FEB).<BR />- MAR will showing total all employment at first month(MAR).<BR />- and onward to Dec.</P><P>Meaning I do not need to select field month to show/presenting total employee at that particular month.<BR />We want it as automatically show on expression on table.<BR />The reason for this we need to sum 3 months and divided by 3 to get average employee.<BR /> What is the correct function/expression can I use?</P><P>Thank you</P></BODY></HTML> Mon, 24 May 2010 06:40:25 GMT 2010-05-24T06:40:25Z Simple: How to show/present specific month? https://community.qlik.com/t5/QlikView/Simple-How-to-show-present-specific-month/m-p/161716#M35502 <HTML><HEAD></HEAD><BODY><P>Hi Guys,<BR /><BR />I have data base called "Employment Date" it take from SQL database.<BR />I already load the "Employment Date" on script.<BR />By using:<BR />Date("Employment Date")<BR />Month("Employment Date")</P><P>Question is how do I able to show/present total every specific month by column in expression.<BR />It should like this below:</P><P>Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec</P><P>- JAN will showing total all employment at first month(JAN).<BR />- FEB will showing total all employment at first month(FEB).<BR />- MAR will showing total all employment at first month(MAR).<BR />- and onward to Dec.</P><P>Meaning I do not need to select field month to show/presenting total employee at that particular month.<BR />We want it as automatically show on expression on table.<BR />The reason for this we need to sum 3 months and divided by 3 to get average employee.<BR /> What is the correct function/expression can I use?</P><P>Thank you</P></BODY></HTML> Mon, 24 May 2010 06:40:25 GMT https://community.qlik.com/t5/QlikView/Simple-How-to-show-present-specific-month/m-p/161716#M35502 2010-05-24T06:40:25Z