active users Retention rate Month On Month

[poojashribanger]

HI All,

I am trying to calculate user retention rate month on month.

I want to calculate Perc Column in Qliksense table 

Formula for Perc is Measure1(Jan)/Measure1(Jan) for jan and for Feb Measure1(feb)/Measure1(Jan) and for march will be measure1(Mar)/measure1(Jan) and so on.

	Jan		Feb
	measure1	Perc	measure1	Perc
01-01-2024	250	100	30	0.12
01-02-2024	120	100	90	0.9
01-03-2024	250	100	30	0.12

Data in Table:

Date	Month	Users	Perc
01-01-2024	jan	250	250/250
01-01-2024	Feb	30	30/250
01-01-2024	mar	25	25/250
01-01-2024	apr	20	20/250
01-02-2024	jan	120	120/120
01-02-2024	feb	90	90/120
01-02-2024	mar	30	30/120
01-02-2024	apr	10	10/120
01-03-2024	Jan	250	250/250
01-03-2024	Feb	30	30/250
01-03-2024	Mar	20	20/250

Can someone please help me on this.

Thanks in Advance

[rubenmarin · Accepted solution]

Hi if you want to conver the second simple table in the first pivot table you can use an expression like:

Sum(Users)/Sum(TOTAL <Date> {<Month={'Jan'}>} Users)

Btw 90/120 is 75%

[poojashribanger]

Thank you so much!

It solved my issue.