topic Re: Qs- % in Pivot table in QlikView

Qs- % in Pivot table

Karahs — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

We have created a pivot table in which one dimension is called as process and one coloumn called as month and two measure called as COUNT(CLIENTCODE) and ??????????????????????

So i want to remove % in that other measure, to remove percentage i used COUNT(TOTAL(CLIENTCODE) which is giving me an wrong answer. Is this the right way if not please suggest me what to do?

eg. COUNT(TOTAL(CLIENTCODE))

ie. 101/238*100 = 42%

But i am getting answr as 10%, Because it is taking all months total, if i want to take only one month total how do i do that?

Please help!!!

Thanks

Re: Qs- % in Pivot table

sunny_talwar — Wed, 27 Apr 2016 15:29:26 GMT

Try this:

Count(CLIENTCODE)/Count(TOTAL <MonthField>CLIENTCODE)

Re: Qs- % in Pivot table

trdandamudi — Wed, 27 Apr 2016 15:31:00 GMT

Can you please post a sample app..

Re: Qs- % in Pivot table

Karahs — Thu, 28 Apr 2016 04:43:06 GMT

Thankyou so much it worked