topic Re: Coulmn Total in QlikView

Coulmn Total

Thu, 19 Jun 2014 05:13:18 GMT

Hi All,

I have this requirement in which i have to show calculated total (formula- Ex-=(Sum of OFE – Sum of Error) / Sum of OFE)total at botton of each coulmn,Like for Apr-2014 may 2014 2014-2015 total should be according to the formula above ??

Re: Coulmn Total

vardhancse — Thu, 19 Jun 2014 05:23:16 GMT

We can get the totals:

Chart properties->Expression:

Select Expression Total:

If we want on first row: select Totals on first row

if we want on last row: select Totals on Last Row

Re: Coulmn Total

Thu, 19 Jun 2014 05:32:04 GMT

hi sasi thank you for guidelines,in my chart Total mode is disabled when i select expresiiion ,cant proceed further?

Re: Coulmn Total

sujeetsingh — Thu, 19 Jun 2014 05:46:52 GMT

You are using Pivot table try using Straight table

Re: Coulmn Total

Thu, 19 Jun 2014 06:10:49 GMT

hi Sujeetsingh,
My coulmn i.e Apr 14 May 14 are not coming in fasion shown, i want it in format shown in my previous attached image.

Re: Coulmn Total

SunilChauhan — Thu, 19 Jun 2014 06:12:41 GMT

convert first in straight table check total for all expression u have

and again convert into Pivot table

hope this helps

Re: Coulmn Total

sujeetsingh — Thu, 19 Jun 2014 06:15:25 GMT

Rohit,

This the limitation of Straight table.

Can you please tell the dimension you are using

Re: Coulmn Total

sujeetsingh — Thu, 19 Jun 2014 06:15:59 GMT

Sunil has a new way try it may it work.

Re: Coulmn Total

Thu, 19 Jun 2014 06:52:53 GMT

we are using Team , Monthyr (Apr 14 may 14)as dimensions

Re: Coulmn Total

sujeetsingh — Thu, 19 Jun 2014 07:14:35 GMT

Have you tried Sunil's method?

Re: Coulmn Total

vardhancse — Thu, 19 Jun 2014 07:28:16 GMT

Yes for pivot table, this option will be disabled.

Try to convert in to straight table

Re: Coulmn Total

vardhancse — Thu, 19 Jun 2014 07:29:45 GMT

In this pivot table, we need to align the field names so that it will come in proper way.

Like drag the fields from row to column

Re: Coulmn Total

Thu, 19 Jun 2014 08:21:22 GMT

yes i did try this method

Re: Coulmn Total

Thu, 19 Jun 2014 08:22:40 GMT

but its giving me output as

Re: Coulmn Total

vardhancse — Thu, 19 Jun 2014 08:29:25 GMT

drag and drop the rows and columns properly

Re: Re: Coulmn Total

SunilChauhan — Thu, 19 Jun 2014 08:41:41 GMT

see the attched example

hope this helps

Re: Coulmn Total

Thu, 19 Jun 2014 13:51:37 GMT

hi sasi i tried but am not able to get Total column at the bottom ,how to do that?

Re: Coulmn Total

vardhancse — Fri, 20 Jun 2014 06:07:52 GMT

Hi Rohit,

Select Totals on Last Row, u can able to see the total in the last row.

In the chart properties->presentation

Select select Show Partial Sums for the dimensions

Re: Coulmn Total

Mon, 23 Jun 2014 12:55:08 GMT

Hello Guys , I want Only Grand total which an expression as total, at the bottom and not the count,grand total as shown in image below in month column,how do i do that,i have also attached sample.qvw in documents kindly check and let me know.