topic Re: Mismatch in QlikView https://community.qlik.com/t5/QlikView/Mismatch/m-p/1436955#M816963 <HTML><HEAD></HEAD><BODY><P>Change Sum(Distinct 1) to Count(Distinct 1)</P><P></P><P>See the attached example.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 06 Sep 2017 09:51:52 GMT kaushiknsolanki 2017-09-06T09:51:52Z Mismatch https://community.qlik.com/t5/QlikView/Mismatch/m-p/1436952#M816960 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have apivot table ...If you look at the&nbsp; last field ( Expression) TotalTime it should display only one row for all the Severity jut like Number is bieng displayed ...</P><P>How can i achieve this ?</P><P></P><P></P><P>Can someone Please Advice on this </P><P>Please find the attachment of the qvw </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Mismatch/m-p/1436952#M816960 smilingjohn 2020-11-25T16:16:04Z Re: Mismatch https://community.qlik.com/t5/QlikView/Mismatch/m-p/1436953#M816961 <HTML><HEAD></HEAD><BODY><P>To get that the expression should be made as dimension.</P><P></P><P>Add below expression in dimension.</P><P>=Aggr(Sum(TotalProjectAllocationhours),ProjectName,ReleaseNumber)</P><P></P><P>And replace existing expression with Sum(distinct 1)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 05 Sep 2017 10:08:51 GMT https://community.qlik.com/t5/QlikView/Mismatch/m-p/1436953#M816961 kaushiknsolanki 2017-09-05T10:08:51Z Re: Mismatch https://community.qlik.com/t5/QlikView/Mismatch/m-p/1436954#M816962 <HTML><HEAD></HEAD><BODY><P>Hi kaushik this is not working ....</P></BODY></HTML> Tue, 05 Sep 2017 14:38:52 GMT https://community.qlik.com/t5/QlikView/Mismatch/m-p/1436954#M816962 smilingjohn 2017-09-05T14:38:52Z Re: Mismatch https://community.qlik.com/t5/QlikView/Mismatch/m-p/1436955#M816963 <HTML><HEAD></HEAD><BODY><P>Change Sum(Distinct 1) to Count(Distinct 1)</P><P></P><P>See the attached example.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 06 Sep 2017 09:51:52 GMT https://community.qlik.com/t5/QlikView/Mismatch/m-p/1436955#M816963 kaushiknsolanki 2017-09-06T09:51:52Z