If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi Qlik Experts
I have two tables. One with Customer ID and joining date and another with Customer ID and transaction date.
I want to measure subscription age of customer using the last transaction date of that year when I select year as dimension.
Example: With the tables below, if I select Date/Year = 2020, Then subscription age for A001 should be (25.10.2020)-(01.05.2019)
I've been trying to use the Firstsorted and Maxdate functions but to no avail.
Any nudge in the the right direction would be greatly appreciated.
With CustID as your dimension, you could use the following as your measure:
View solution in original post
Brilliant Thanks. Worked like a charm!