topic Re: Noobie question in QlikView

Noobie question

Mon, 26 Nov 2012 14:58:12 GMT

I have one expression which says Sum (tot_engasjem)-Sum (Volum)

This expression is labeled Unyttet. This one works just fine.

Then secondly I want have that as an percentage and I have an expression which is

Sum (Unyttet)/Sum (TOTAL(Unyttet))

That only yields empthy cells.

Re: Noobie question

jonathandienst — Mon, 26 Nov 2012 15:19:04 GMT

You can't perform aggregation on named columns (Unyttet) in a chart or table. You will need to do something like this:

Sum(Aggr(Sum((tot_engasjem)-Sum(Volum)), dim1, dim2, ...)) /

Sum(Total Aggr(Sum((tot_engasjem)-Sum(Volum)), dim1, dim2, ...))

Where dim1, dim2, ... is a comma seprated list of all the fields used as dimensions on your chart/table.

Regards

Jonathan

Re: Noobie question

Tue, 27 Nov 2012 08:06:19 GMT

Since I only have one dimension called Klasse, the expression should look something like this?

Sum(Aggr(Sum((tot_engasjem)-Sum(Volum)), Klasse)) /

Sum(Total Aggr(Sum((tot_engasjem)-Sum(Volum)), Klasse))

However this yields only -

Re: Noobie question

jagan — Tue, 27 Nov 2012 08:32:08 GMT

Hi,

Try this

=Sum ([Unyttet])/(Sum (TOTAL tot_engasjem)-Sum (TOTAL Volum))

=Sum ([Unyttet])/Sum (TOTAL [Unyttet])

Hope this helps you.

Regards,

Jagan.

Re: Noobie question

Tue, 27 Nov 2012 09:45:21 GMT

Sorry but neither of those seem to work. I still get just a - .

Re: Noobie question

jagan — Tue, 27 Nov 2012 09:47:53 GMT

HI,

Can you attach sample file that you are working.

Regards,

Jagan.

Re: Noobie question

jonathandienst — Wed, 28 Nov 2012 13:34:02 GMT

I thnk there is a bracket out of place. Try this:

Sum(Aggr(Sum((tot_engasjem)-Sum(Volum)), Klasse)) / Sum(Total Aggr(Sum(tot_engasjem)-Sum(Volum), Klasse))

Jonathan

Re: Noobie question

jonathandienst — Wed, 28 Nov 2012 13:36:05 GMT

And if that is still not right, you could try other positions for the total:

Sum(Aggr(Sum((tot_engasjem)-Sum(Volum)), Klasse)) / Sum(Aggr(Sum(Total tot_engasjem)-Sum(Total Volum), Klasse))

Sum(Aggr(Sum((tot_engasjem)-Sum(Volum)), Klasse)) / Sum(Total Aggr(Sum(tot_engasjem-Volum), Klasse))

Sum(Aggr(Sum((tot_engasjem)-Sum(Volum)), Klasse)) / Sum(Aggr(Sum(Total tot_engasjem-Volum), Klasse))

Can't be sure as I am guessing in the absence of a sample model to test on.

Jonathan