topic Re: Re: Problem with % expression in chart in QlikView

Problem with % expression in chart

amber2000 — Fri, 30 May 2014 15:15:14 GMT

Hello everyone,

I'm strugling again with creating an expression in a chart.

I have 3 fields called Zone ,Tendu/Stock and Colli.

I want to see by Zone how may % is Tendu and how many % is Stock in a chart.

No clue what so ever on how I can manage this, can someone help me please, I've attached the QVW with the data.

Kind regards,

Monique

Re: Problem with % expression in chart

Fri, 30 May 2014 15:27:07 GMT

Are you trying to see by zone what percent of the colli are stock or tendu?

Re: Problem with % expression in chart

amber2000 — Fri, 30 May 2014 15:30:54 GMT

Yes that's what I'm trying to see but I want to see both Stock % and Tendu %

Both accumulated should be 100%

Re: Problem with % expression in chart

maxgro — Fri, 30 May 2014 15:33:56 GMT

if you want this

- remove dimension Colli

- add expression Sum(Colli) / sum(TOTAL <Zone> Colli)

and format in Number tab

if not, you probably have to play with the TOTAL

Re: Problem with % expression in chart

Anonymous — Fri, 30 May 2014 15:34:11 GMT

See attached

Re: Re: Problem with % expression in chart

venkatg6759 — Fri, 30 May 2014 15:34:53 GMT

Check if this helps .

Re: Re: Problem with % expression in chart

Fri, 30 May 2014 15:35:47 GMT

Like this?

Re: Problem with % expression in chart

alexpanjhc — Fri, 30 May 2014 15:38:02 GMT

I hope this helps.

Re: Re: Problem with % expression in chart

amber2000 — Fri, 30 May 2014 15:49:17 GMT

Thank you so much, can you explain to me how the expression is working step by step please?

I don't just want to copy code but try to understand so I can manage these things myself.

Monique

Re: Re: Problem with % expression in chart

amber2000 — Fri, 30 May 2014 15:55:12 GMT

Yes this is very clear but I've seen a different way of expression that is not completly clear to me:

sum([Colli]) / Sum(TOTAL<Zone>Colli)

Re: Re: Re: Problem with % expression in chart

maxgro — Fri, 30 May 2014 16:09:46 GMT

see attachment

or from online help

If the word total occurs before the function arguments the calculation will be made over all possible values given the current selections but disregarding the chart dimension variables.

The total qualifier may be followed by a list of one or more field names within angle brackets. These field names should be a subset of the chart dimension variables. In this case the calculation will be made disregarding all chart dimension variables except those listed, i.e. one value will be returned for each combination of field values in the listed dimension fields. Also fields which are not currently a dimension in a chart may be included in the list. This may be useful in the case of group dimensions, where the dimension fields are not fixed. Listing all of the variables in the group causes the function to work when the cycle or drill-down level changes.

Re: Re: Problem with % expression in chart

Anonymous — Fri, 30 May 2014 16:11:17 GMT

sum(Colli) / sum(total<Zone> Colli)

The "total" qualifier makes expression to ignore dimensions of the chart. The total<Zone> tells to ignore dimension except Zone. That is you get sum logically "grouped by" Zone.

See "help" regarding "total' and "all" for more details.

Re: Re: Re: Problem with % expression in chart

amber2000 — Tue, 03 Jun 2014 15:56:07 GMT

A big thanks to all who helped me, I am so gratefull and also for explaining the solution.

This is really educational.

Monique