topic Re: Percentage issue.. in QlikView

Percentage issue..

paulwalker — Wed, 01 Jan 2014 16:33:17 GMT

Hi All,

PFA,

Here calculating Actual vs Demand

AD %age= Demand/Actual..

--Paul

Re: Percentage issue..

paulwalker — Wed, 01 Jan 2014 16:33:56 GMT

Total sum it Should be 100%

Re: Percentage issue..

MK_QSL — Wed, 01 Jan 2014 17:11:41 GMT

Try This.... and it cant be 100% as Actual and Demand is not equal.

AD % age

Alt(SUM(Demand)/SUM(Actual),0)

Re: Percentage issue..

stevedark — Wed, 01 Jan 2014 17:13:29 GMT

You should always use aggregations in expressions, so I would expect the expression to read like:

sum(Demand)/sum(Actual)

The only time you wouldn't do this if if you were referencing prior columns, eg.:

[Actual Demand] / [Monthly Coverage]

In this case the aggregations are done in the other columns.

Not sure what you mean by the total should be 100% - as each row is independent of the others. To get the contribution of the demand to the whole you could add an expression like this:

sum(Demand) / sum(TOTAL Demand)

This will divide the value on each row by the total across all rows.

Hope that helps.

Steve

Re: Percentage issue..

rustyfishbones — Wed, 01 Jan 2014 17:16:26 GMT

Hi Paul,

You are saying Demand/Actual.

Should it be SUM(Demand)/SUM(Actual)

regards

Alan

Re: Percentage issue..

paulwalker — Wed, 01 Jan 2014 17:34:24 GMT

Hello Steve,

sum(Demand) / sum(TOTAL Demand)

it's show perfect 100% of the data..

why are You using (TOTAL) Function here...

Re: Percentage issue..

nirav_bhimani — Wed, 01 Jan 2014 18:11:09 GMT

Hi,

If we are using Total Keyword then It will consider Entire set for that Field & show the result.

Formula should be

SUM(Demand)/SUM(Actual)

Regards,

Nirav Bhimani

Re: Percentage issue..

stevedark — Wed, 01 Jan 2014 19:58:01 GMT

Hi Paul,

The TOTAL keyword gives the total for that sum (or any aggregation) regardless of the dimension. This means you are dividing the Demand for one row by the total demand for all rows (and on the total row it is the Total divided by itself - i.e. 1).

If you create a new expression with just sum(TOTAL Demand) in it you will see it has the same value on every row.

Hope that helps explain.

Cheers,

Steve