topic Re: Custom percentage calculation in QlikView

Custom percentage calculation

Anonymous — Wed, 04 Mar 2015 13:10:06 GMT

Hi All

In below (and attached QV) I need custom percentage, How this possible please?

Perc = (TotalValue / Mar-2012 (15627.62) )* 100

So for Jan-2012 -> (8891.78/15627.62) * 100 = 56.90% and so on

(Mar-2012 value is denominator always in this case)

I appreciate your help

Thanks

Re: Custom percentage calculation

Gysbert_Wassenaar — Wed, 04 Mar 2015 13:21:58 GMT

See attached qvw.

Re: Custom percentage calculation

simenkg — Wed, 04 Mar 2015 13:33:24 GMT

You can create a variable that that will calculate March-value and calculate with it.

create a variable vThisMonthValue as:

=Sum({<YearMonth={$(=Only({<Date={Today}>}YearMonth))}>}Value)

then your expression becomes:

Sum(Value)/$(vThisMonthValue)

if you only need to do this for the total column, then play around with:
Dimensionality() and SecondaryDimensionality() and use them in an if:

i.e:
if(Dimensionality()=0 and SecondaryDimensionality() = 1,

sum(Value)/$(vThisMonthValue)

sum(Value/SomeOtherValue

)

Re: Custom percentage calculation

Anonymous — Wed, 04 Mar 2015 13:34:46 GMT

Hi Gysbert

There is no attachment please.

Thanks

Re: Custom percentage calculation

Anonymous — Wed, 04 Mar 2015 13:51:13 GMT

Hi Simen

I appreciate your prompt reply. In my case(attached QV) has only one dimension, And 'Perc' column is aggregated, I need effect in particular this column only.

Thanks for your time and effort