topic Re: Want to get Column Total in Row in QlikView

Want to get Column Total in Row

ferha_jafri — Fri, 26 Jul 2019 14:36:47 GMT

Hello Experts,

I want to add column total and get its value in row.Please find attachment as you will see in the attachment I want to get column Total on the right hand side value in the Total row.

Thanks in advance.

Re: Want to get Column Total in Row

Anil_Babu_Samineni — Fri, 26 Jul 2019 14:57:18 GMT

Like this?

Re: Want to get Column Total in Row

ferha_jafri — Fri, 26 Jul 2019 15:01:21 GMT

Re: Want to get Column Total in Row

Anil_Babu_Samineni — Fri, 26 Jul 2019 15:02:38 GMT

Please describe in image after you export that into excel.

Re: Want to get Column Total in Row

ferha_jafri — Fri, 26 Jul 2019 15:51:25 GMT

If you check the pivot attached in the sample I want column total on right to come in expression name as Total.

Re: Want to get Column Total in Row

sunny_talwar — Fri, 26 Jul 2019 18:06:24 GMT

You want something like this?

Re: Want to get Column Total in Row

ferha_jafri — Sun, 28 Jul 2019 00:52:53 GMT

Thanks for your reply but I want to get for priority 1,category 1 total which is 4 to come under total for priority 1 , category 1.I want to evaluate % for them as there corresponding value 3/ 4.

Re: Want to get Column Total in Row

ferha_jafri — Sun, 28 Jul 2019 08:02:47 GMT

Hello ,

Not able to find solution to this , if anyone worked on a similar case then please reply.

Re: Want to get Column Total in Row

sunny_talwar — Mon, 29 Jul 2019 11:21:49 GMT

This?

Expression for TOTAL

Count(TOTAL <Prioity, Category> Documnet)

Re: Want to get Column Total in Row

ferha_jafri — Mon, 29 Jul 2019 11:38:46 GMT

You are great , thank you so much this is what I was looking for...