How to Retriev Max(endtimedate) for All Users Over the Last Six Months in Qlik Cloud #42
Description
I want to get a list of users who have been using Qlik Cloud in the last six months. However, when using the Max(endtimedate) field, I can only see users from last month and this month, as shown in the image. Additionally, it includes null values for users who have not accessed the cloud in over two months.
How can I retrieve the Max(endtimedate) for all assignee users in the cloud, ensuring I capture data for the entire six-month period with emails in entitlement analyzer ? Could you please help me?
