Discussion Board for collaboration related to QlikView App Development.
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
See attached qvw.
View solution in original post
You can create a variable that that will calculate March-value and calculate with it.
create a variable vThisMonthValue as:
then your expression becomes:
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,
There is no attachment please.
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