Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is the expression for vSetMATLYDollar?
Hi Sunny. It is:
Num(sum({<[Date Dispensed]={">=$(=addmonths(MonthEnd(max([Date Dispensed]),)+1,-24)) <=$(=addmonths(MonthEnd(max([Date Dispensed])),-12))"}>}Amount), '$##,##0.00')
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), '##%')
Thanks Sunny, the expression gives a blank value.
Can you share a sample to look at?