topic Re: Show total row wise in pivot table in QlikView

Show total row wise in pivot table

yashcena — Thu, 06 Jul 2017 07:13:23 GMT

I have a pivot table which shows the count of test cases and I'm showing it horizontally.

(image from an excel export)

I want to show the percentage row wise. Instead, it is calculating the percentage column-wise.

For example, in CR4701 US130543 there are 12 test cases and all of them are in Pass state. So the pass percentage should be 100%. Instead, it is calculating the percentage by taking all the 'Pass' test cases i.e. 195 [(12/195)*100]. It should calculate only for that particular CR.

Is there any way to do that? I hope I have made my requirement clear.

Expression for count:

count(TestCaseID)

Expression for Percentage:

count(TestCaseID)/count(total(TestCaseID))

(I think for the % expression, the denominator is wrong.)

Thanks,

YASH

Re: Show total row wise in pivot table

kaushiknsolanki — Thu, 06 Jul 2017 07:24:12 GMT

Hi,

Try this.

count(TestCaseID)/count(total<TestCaseCRs>(TestCaseID))

Regards,

Kaushik Solanki

Re: Show total row wise in pivot table

yashcena — Thu, 06 Jul 2017 09:08:59 GMT

Hi Kaushik....this expression did not work.

Re: Show total row wise in pivot table

BalaBhaskar_Qlik — Thu, 06 Jul 2017 09:30:22 GMT

May be these:

Count(TestCaseID)/Count(total <DIM1> TestCaseID)

Count(TestCaseID)/Count(total <DIM1, DIM2> TestCaseID)

if(dimensionality()=0, Count(TestCaseID)/Count(total <DimA> TestCaseID), sum(TestCaseID)) // (Think so)

Re: Show total row wise in pivot table

Kushal_Chawda — Thu, 06 Jul 2017 09:30:38 GMT

Would you be able to share the sample file?

Re: Show total row wise in pivot table

Kushal_Chawda — Thu, 06 Jul 2017 09:32:45 GMT

Preparing examples for Upload - Reduction and Data Scrambling

Re: Show total row wise in pivot table

yashcena — Thu, 06 Jul 2017 10:08:12 GMT

I'm not able to find the option to attach .qvw. Drag and drop also didnt work

Re: Show total row wise in pivot table

yashcena — Thu, 06 Jul 2017 10:08:50 GMT

Hi Bala..i tried this expression but it didnt work. Kaushik had already asked me to try it.

thanks..

Re: Show total row wise in pivot table

kaushiknsolanki — Thu, 06 Jul 2017 10:15:39 GMT

Hi,

See the attached app.

Regards,

Kaushik Solanki

Re: Show total row wise in pivot table

sunny_talwar — Thu, 06 Jul 2017 11:25:22 GMT

Look here

Uploading a Sample

Re: Show total row wise in pivot table

BalaBhaskar_Qlik — Sun, 02 Sep 2018 14:56:00 GMT

Did you resolved the issue, post the solution.