topic Re: Totals in straight table in QlikView

Totals in straight table

Anonymous — Mon, 08 Feb 2016 11:44:54 GMT

Hi ,

I am facing problem with count of totals in straight table.I used Expression total for calculating totals and values are in percentages and fixed them to .1 decimal .

Any Ideas are appreciated

Re: Totals in straight table

sunny_talwar — Mon, 08 Feb 2016 11:46:49 GMT

I don't understand the issue you are facing here? Can you pinpoint the problem for us?

Re: Totals in straight table

Anonymous — Mon, 08 Feb 2016 11:54:42 GMT

Sorry for inappropriate data .

Could you please look into the attached image. Totals for Weight is not correct .It is showing 100% which is incorrect .It should give totals which are sum of its below values

Re: Totals in straight table

Mark_Little — Mon, 08 Feb 2016 11:57:36 GMT

Hi,

I am with Sunny, from what you have said and the screen shot, you are getting what i would expect to see.

Maybe if you show what you are expecting or wanting to see in the total?

Mark

Re: Totals in straight table

avinashelite — Mon, 08 Feb 2016 11:58:41 GMT

could you please share the expression your using ....so that we can help you out on the same

Re: Totals in straight table

Anonymous — Mon, 08 Feb 2016 12:10:49 GMT

The expression is

Sum(CY_DAY_NET_SALES)/Sum(Total CY_DAY_NET_SALES).

I used expression totals for Calculating totals .

Re: Totals in straight table

Mon, 08 Feb 2016 12:18:38 GMT

Step 1. In expression tab select Sum (of rows)

Step 2. Go to Number tab and select integer and check "Show in percentage" check box.

i wish this will help you.

Re: Totals in straight table

settu_periasamy — Mon, 08 Feb 2016 12:24:22 GMT

Did you try 'Sum' in total mode (expression tab)?

Re: Totals in straight table

avinashelite — Mon, 08 Feb 2016 12:35:03 GMT

Try un-checking the relative option ...Or use the SUM option in the total

Re: Totals in straight table

jonathandienst — Mon, 08 Feb 2016 12:40:21 GMT

Well if you want sum of rows, then use that option for that expression. The first expression can be an expression total.

Re: Totals in straight table

sasikanth — Mon, 08 Feb 2016 13:02:18 GMT

Hi,

As per your image , Sum of all the % values shown below is equal to 100%

14.3+7.2+12.3+19.6+25.8+16.7+4.1=100

What exactly you want to achieve ?

Re: Totals in straight table

Anonymous — Tue, 09 Feb 2016 06:58:16 GMT

Yes ! It's equal to 100% .I resolved it .

Re: Totals in straight table

Anonymous — Tue, 09 Feb 2016 07:00:26 GMT

I resolved it .Thank you all for your time