Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
badzreyes
Contributor II
Contributor II

Monthly Growth Rate Min to Max dates

Hi Everyone!

Can you guys help me with my formula? I have a trend chart that counts Total customer count acquisition monthly from 2018 up to latest date and I want to create another trend chart that shows its Growth Rate %.

My Original Trend chart is below:

Customer_Acquisition_Tren.PNG

The customer count formula for that is:

COUNT({$<DateBasis={"X"}>}  distinct [Y])

Formula that I tried:

1. ((COUNT({$<DateBasis={"X"}>}  distinct [Y]))/(Before(COUNT({$<DateBasis={"X"}>}  distinct [Y])) - 1) * Avg(1)))

2.  (COUNT({$<DateBasis={"X"}, MonthNum={$(=Max(MonthNum))}>}  distinct [Y])) - 

(COUNT({$<DateBasis={"X"}, MonthNum={$(=Max(MonthNum)-1)}>}  distinct [Y])) /

(COUNT({$<DateBasis={"X"}, MonthNum={$(=Max(MonthNum)-1)}>}  distinct [Y]))

 

Thank you so much and have a great day!

Labels (5)
3 Replies
kashyap
Partner
Partner

Hi 

Try this 

(Count({$<DateBasis={"X"}>}  distinct [Y])-Below({$<DateBasis={"X"}>}  distinct [Y]))
/
({$<DateBasis={"X"}>}  distinct [Y])

Note : Make sure to sort by ascending order the yearmonth and give fnumber format to numer and set % format

Hope this helps

Thanks

badzreyes
Contributor II
Contributor II
Author

Thank you for your response,

Unfortunately, it does not give me any result 😞 I just get ' - ' as a result in each row(I am trying the formula in a table first and splitting each expression into column to see where it went wrong but each doesn't gave me any result)

My dimension - ' YearMonthNum'

Measurement - 'Customer Count'(Current measurement that I want to convert into Growth Rate %) = COUNT({$<DateBasis={"X"}>}  distinct [Y])

Regards,

Badz

Kush
MVP
MVP

try this

=num(alt((COUNT({$<DateBasis={"X"}>}  distinct [Y])-
Above(total COUNT({$<DateBasis={"X"}>}  distinct [Y])))/
Above(total COUNT({$<DateBasis={"X"}>}  distinct [Y])),0),'#0.00%')