topic total in straight table in QlikView

total in straight table

Wed, 14 Mar 2012 12:10:46 GMT

Hi,

I have a straight table that shows the top 50 SKUs. Here's the image:

When I show the total FY201 and FY2011 columns give me the correct totals but the total in %Change, %YAGO and %Share doesn't give me the correct total. I want to show the total of 50 SKUs.. How can I do this?

total in straight table

CELAMBARASAN — Wed, 14 Mar 2012 12:18:49 GMT

Hi,

Change the option to that expression Sum of rows.

Chart Properties-->Expression Tab-->Under Total Mode Check the Sum of rows.

Celambarasan

total in straight table

Wed, 14 Mar 2012 12:24:28 GMT

I already used that option, still gives me the wrong output

total in straight table

CELAMBARASAN — Wed, 14 Mar 2012 12:33:40 GMT

Hi,

Can you post your expression ?

Celambarasan

total in straight table

jagan — Wed, 14 Mar 2012 12:33:50 GMT

Hi,

What are your percentage expressions?

Try using

=Sum(Your Percentage expression here)

and select Chart Properties-->Expression Tab-->Under Total Mode Check the Sum of rows.

Hope it helps you.

Regards,

Jagan.

total in straight table

Thu, 15 Mar 2012 02:25:55 GMT

here are my Percentage expressions:

For,

%Change:

( Sum({<fin_year={$(vMaxFinYear)}>}extended_price) - Sum({<fin_year={$(vPrevFinYear)}>}extended_price) )

/ Sum({<fin_year={$(vPrevFinYear)}>}extended_price)

%YAGO:

Sum({<fin_year={$(vMaxFinYear)}>}extended_price) / Sum({<fin_year={$(vPrevFinYear)}>}extended_price)

%Share:

Sum({$<fin_year={$(vMaxFinYear)}>}extended_price) / Sum(TOTAL extended_price)

total in straight table

Thu, 15 Mar 2012 04:24:19 GMT

can somebody help me??

total in straight table

Thu, 15 Mar 2012 05:35:29 GMT

total in straight table

CELAMBARASAN — Thu, 15 Mar 2012 05:40:13 GMT

Hi,

Try your expression as

if(Rowno()>0,

( Sum({<fin_year={$(vMaxFinYear)}>}extended_price) - Sum({<fin_year={$(vPrevFinYear)}>}extended_price) )

/ Sum({<fin_year={$(vPrevFinYear)}>}extended_price),

( Sum(TOTAL {<fin_year={$(vMaxFinYear)}>}extended_price) - Sum( TOTAL {<fin_year={$(vPrevFinYear)}>}extended_price) )/Sum(TOTAL {<fin_year={$(vPrevFinYear)}>}extended_price))

Celambarasan

total in straight table

Thu, 15 Mar 2012 05:53:58 GMT

It still gives me the wrong output

total in straight table

Thu, 15 Mar 2012 09:21:18 GMT

any ideas???