5 Replies Latest reply: Jan 2, 2016 7:43 PM by Sunny Talwar

# Calculating relative values in QlikSense

How does one calculate a relative value in QlikSense?  With QlikView for example using the following expression and ticking 'Relative' will do the trick:

\$(vSetMATLYDollar)

In QlikSense, i tried something like the following:

\$(vSetMATLYDollar)/total(\$(vSetMATLYDollar))

which does not work.  How can this be done in QlikSense?

Regards.

• ###### Re: Calculating relative values in QlikSense

What is the expression for vSetMATLYDollar?

• ###### Re: Calculating relative values in QlikSense

Hi Sunny.  It is:

Num(sum({<[Date Dispensed]={">=\$(=addmonths(MonthEnd(max([Date Dispensed]),)+1,-24)) <=\$(=addmonths(MonthEnd(max([Date Dispensed])),-12))"}>}Amount), '\$##,##0.00')

• ###### Re: Calculating relative values in QlikSense

May be this:

Num(Sum({<[Date Dispensed]={">=\$(=addmonths(MonthEnd(max([Date Dispensed]),)+1,-24)) <=\$(=addmonths(MonthEnd(max([Date Dispensed])),-12))"}>}Amount)/Sum(TOTAL{<[Date Dispensed]={">=\$(=addmonths(MonthEnd(max([Date Dispensed]),)+1,-24)) <=\$(=addmonths(MonthEnd(max([Date Dispensed])),-12))"}>}Amount), '##%')

• ###### Re: Calculating relative values in QlikSense

Thanks Sunny, the expression gives a blank value.

• ###### Re: Calculating relative values in QlikSense

Can you share a sample to look at?