topic Re: Difference between sum and expression Total in Straight table in QlikView

Difference between sum and expression Total in Straight table

sundarakumar — Wed, 08 Jan 2014 05:49:14 GMT

Hi,

Can anyone please tell me the difference between sum and Expression total in the expression tab of Straight table?

Re: Difference between sum and expression Total in Straight table

Wed, 08 Jan 2014 05:51:36 GMT

Grand total of the expression. u can suppress the Grand total by selecting No Total Option.

Re: Re: Difference between sum and expression Total in Straight table

sundarakumar — Wed, 08 Jan 2014 06:05:02 GMT

Hi Raja,

Thanks for the reply.

I want to know the difference between 'expression total' and 'sum', as highlighted in the below picture. The Problem is not about showing the total or hiding it...

Re: Difference between sum and expression Total in Straight table

Wed, 08 Jan 2014 06:29:15 GMT

Hi Sundarakumar,

I lot cases the output of the both options is same. Except the some Situation Like, when you are having for one parent node as two child's (Value 100) the total of parent in Expression Total is 10 and sum total will be 20.

Re: Difference between sum and expression Total in Straight table

jagan — Wed, 08 Jan 2014 06:46:17 GMT

Hi,

Sum - will give you the sum of all rows in the table

Expression Total - will give you the overall expression total.

Regards,

Jagan.

Re: Difference between sum and expression Total in Straight table

sundarakumar — Wed, 08 Jan 2014 06:49:44 GMT

Do u mean it like, Expression total will return in the sum without considering what dimension we are using?

Re: Difference between sum and expression Total in Straight table

Wed, 08 Jan 2014 06:51:17 GMT

Hi Sundar,

PFA...

Reagrds,

raja

Re: Difference between sum and expression Total in Straight table

sundarakumar — Wed, 08 Jan 2014 06:53:47 GMT

Thanks for the reply, sorry i dont understand what u r trying to explain.

Can u please elaborate?

Re: Difference between sum and expression Total in Straight table

jagan — Wed, 08 Jan 2014 06:57:43 GMT

Hi,

Sum - will give you the sum of all rows in the table

Expression Total - will give you the overall expression total.

For example:

Year A B

2013 50 100

2014 50 150

When you use A/B as expression and use Year as Dimension

Sum Mode - 83% (50 + 33) (50/100 + 50/150 = 50% + 33 % = 83%)

Expression Mode - 40% (100/250) (50 + 50) / (100 + 150)

Regards,

Jagan.

Re: Difference between sum and expression Total in Straight table

Anonymous — Wed, 08 Jan 2014 07:01:09 GMT

Difference is shown significantly when using distinct in expressions,

Expression Total Calculates the Expression regardless of all dimensions just similar as you write your expression in a text box.

Sum of Rows > Sums the values calculated by expression in all rows of the chart.

Re: Re: Difference between sum and expression Total in Straight table

sundarakumar — Wed, 08 Jan 2014 07:20:06 GMT

Hi jagan,

Please find the attachment.

Y am i not getting the expression total in it? I have used what you have explained above in the app.

Can you please explain?

Thanks for the response.

-Sundar

Re: Difference between sum and expression Total in Straight table

Wed, 08 Jan 2014 07:23:39 GMT

Yes Jagan Exatly..Thanks

Based on the your needs you can set.

Fr example,

If you want max sale or min sales, avg sales, least year sales..