topic Re: Partial sums expression in QlikView

Partial sums expression

Tue, 04 Jun 2013 07:54:08 GMT

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???

Re: Partial sums expression

Anonymous — Tue, 04 Jun 2013 08:05:11 GMT

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

Re: Partial sums expression

Joaquin_Lazaro — Tue, 04 Jun 2013 10:31:13 GMT

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.

Re: Partial sums expression

Tue, 04 Jun 2013 10:33:18 GMT

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>

Re: Partial sums expression

Joaquin_Lazaro — Tue, 04 Jun 2013 10:50:32 GMT

this image come from a straight table chart properties:

Re: Partial sums expression

Tue, 04 Jun 2013 11:13:05 GMT

Can you please attach the sample app

Re: Partial sums expression

Joaquin_Lazaro — Tue, 04 Jun 2013 13:13:19 GMT

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.

Re: Partial sums expression

Wed, 05 Jun 2013 05:41:48 GMT

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>

Re: Partial sums expression

Wed, 05 Jun 2013 05:43:51 GMT

Hi Polschou,

Can you let me know which chart are you using

Re: Partial sums expression

Wed, 05 Jun 2013 06:14:49 GMT

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>