Partial sums expression

[#1]

I have tabbed show partial sums on my month dimension and get a total column.

Is it possible to change the expression i partial sums to not just accumulate the amount for each month.

I got an expression that count sold items

            Jan       feb     mar    total

item      100       200    300     600

ex. I want to the total to be the year average so I want to divide the 600/12

is this possible???

[Anonymous]

I don't think there is a way of changing the Partial sum expression.

You could try adding logic into the expression to say that if there is more than one month then it should divide by the number of months, but I think the partial sum sums up the months, instead of repeating the expression over the total number of columns.

How about adding in year as a dimension and including logic in the expression to say that if there is more than one month then it should divide by the number of months ?

Jonathan

[Joaquin_Lazaro]

Hi polschou

If your total field come from the Expression Total 

Test this: In ChartProperties, select the expression tab, in the Total Mode Box open the list box and select Average.

[#4]

Hi

My total field comes for tabbing the SHOW PARTIAL SUMS

Fra: joaquinlr

Sendt: 4. juni 2013 12:31

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: Partial sums expression

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Partial sums expression

created by joaquinlr<http://community.qlik.com/people/joaquinlr> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/353047#353047>

[Joaquin_Lazaro]

this image come from a straight table chart properties:

[#6]

Can you please attach the sample app

[Joaquin_Lazaro]

The are some things that I can't do ... app always have data.

But the steps, wiht your data loaded, are:

1) Add a new chart object to your app

2) Select Straight Table type

3) Add one or more dimensions

4) Add one or more expressions, for each expression select on the Total Mode Box the kind of total you like.

Good luck.

[#8]

Hi joaquinir

The Total Mode Box is dimmed out(not optional)

Regards

Søren

Fra: joaquinlr

Sendt: 4. juni 2013 15:13

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: Partial sums expression

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Partial sums expression

created by joaquinlr<http://community.qlik.com/people/joaquinlr> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/353140#353140>

[#9]

Hi Polschou,

  Can you let me know which chart are you using

[#10 · Accepted solution]

Hi

Sorry my fault – I was´nt using the right chart

When using straight table I got the total mode box

thanx

Fra: nirmal.j

Sendt: 5. juni 2013 07:44

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: Partial sums expression

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Partial sums expression

created by nirmal.j<http://community.qlik.com/people/nirmal.j> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/353385#353385>