Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chitemerere
Valued Contributor

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.

5 Replies
MVP
MVP

Re: Calculating relative values in QlikSense

What is the expression for vSetMATLYDollar?

chitemerere
Valued Contributor

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')

MVP
MVP

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

chitemerere
Valued Contributor

Re: Calculating relative values in QlikSense

Thanks Sunny, the expression gives a blank value.

MVP
MVP

Re: Calculating relative values in QlikSense

Can you share a sample to look at?