Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below is an excel spreadsheet displaying the total number of users from MTM (57,642...). I'm having an issue getting that column to populate in Qlik Sense.
Excel Total Number of Users MTM
Here's what I am able to create which is the number of users for that month but not a rolling MTM.
Qlik Sense Users Created MTM
Thank you in advance!
How about this
RangeSum( Count(TOTAL User), -RangeSum(Above(Count(User), 1, RowNo())) )
Assuming your expression for User Count is Count(User), try this
RangeSum(Below(Count(User), 0, RowNo()))
Thank you for the quick response.
The formula's adding MTM: Nov & Dec providing a total of 679 but I was hoping to see the totals in the second screenshot:
How about this
RangeSum( Count(TOTAL User), -RangeSum(Above(Count(User), 1, RowNo())) )
That did it 🙂
Thank you so much, I appreciate the help!!!