topic Re: Pivot chart showing incorrect values. in QlikView https://community.qlik.com/t5/QlikView/Pivot-chart-showing-incorrect-values/m-p/594021#M1121467 <HTML><HEAD></HEAD><BODY><P>Great Gysbert .Thanks and this works perfect.</P></BODY></HTML> Fri, 31 Jan 2014 14:23:24 GMT 2014-01-31T14:23:24Z Pivot chart showing incorrect values. https://community.qlik.com/t5/QlikView/Pivot-chart-showing-incorrect-values/m-p/594019#M1121465 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find attached and help me as I have to show the which lists each person in the team and the number of work items they have closed. In addition to that I need a breakdown of the individual work item types each individual closed.</P><P></P><P>I did pivot chart but it seems the data is not showing correctly. please can anyone let me know how to set this.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 31 Jan 2014 14:08:46 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-showing-incorrect-values/m-p/594019#M1121465 2014-01-31T14:08:46Z Re: Pivot chart showing incorrect values. https://community.qlik.com/t5/QlikView/Pivot-chart-showing-incorrect-values/m-p/594020#M1121466 <HTML><HEAD></HEAD><BODY><P>Try these expressions instead:</P><P>count({&lt;Details={'Closed','closed'}&gt;}1)</P><P>count({&lt;Details={'Future Date'}&gt;}1)</P></BODY></HTML> Fri, 31 Jan 2014 14:14:47 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-showing-incorrect-values/m-p/594020#M1121466 Gysbert_Wassenaar 2014-01-31T14:14:47Z Re: Pivot chart showing incorrect values. https://community.qlik.com/t5/QlikView/Pivot-chart-showing-incorrect-values/m-p/594021#M1121467 <HTML><HEAD></HEAD><BODY><P>Great Gysbert .Thanks and this works perfect.</P></BODY></HTML> Fri, 31 Jan 2014 14:23:24 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-showing-incorrect-values/m-p/594021#M1121467 2014-01-31T14:23:24Z