topic Re: Pivot table in QlikView https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1260434#M855515 <HTML><HEAD></HEAD><BODY><P>Hi James,</P><P></P><P>if you share sample source data &amp; expected output then our folks will help to you.</P><P>Else it is too tough to find the solution like this image.</P></BODY></HTML> Mon, 13 Feb 2017 09:22:35 GMT ramasaisaksoft 2017-02-13T09:22:35Z Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1260433#M855514 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>Please see the attached, I am struggling to do a few things.</P><P></P><P>One is that for month 201604 i would like it to count the number of working days in that month, I have put workingdays as 1 if it is a working day.</P><P></P><P>I would also like to compare with the same month but last year, but struggling to figure it out, not sure how i would pivot it as i would like it to be</P><P></P><P>201604 201504</P><P></P><P>I also note I spelt 'SUM' wrong, but it didn't work even when it was correct to be fair.</P><P></P><P>Your help would be much appreciated,</P><P></P><P>James.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1260433#M855514 james_hanify 2020-11-25T16:16:04Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1260434#M855515 <HTML><HEAD></HEAD><BODY><P>Hi James,</P><P></P><P>if you share sample source data &amp; expected output then our folks will help to you.</P><P>Else it is too tough to find the solution like this image.</P></BODY></HTML> Mon, 13 Feb 2017 09:22:35 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1260434#M855515 ramasaisaksoft 2017-02-13T09:22:35Z