Calculating relative values in QlikSense

[Anonymous]

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.

[sunny_talwar]

What is the expression for vSetMATLYDollar?

[Anonymous]

Hi Sunny.  It is:

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

[sunny_talwar]

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), '##%')

[Anonymous]

Thanks Sunny, the expression gives a blank value.

[sunny_talwar]

Can you share a sample to look at?