# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
Creator II

## Custom percentage calculation

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)

Thanks

1 Solution

Accepted Solutions

See attached qvw.

talk is cheap, supply exceeds demand
4 Replies

See attached qvw.

talk is cheap, supply exceeds demand
Partner

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)

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

)

Creator II
Author

Hi Gysbert