Search in a same table a license Renewal - Qlik Sense
I need to solve a problem that arises when I have to show on a board, the list of Licenses that were renewed. I must also show a KPI with the amount of renewed licenses vs. those that are available for renewal. The data schema of the Orders table has many records, but the most important ones are: Order date ID Order (Unique) User license (this value is repeated in the renewal records) Expiration Date (one, two, three years)
As I mention, the field that is maintained is the User field (license identifier) throughout its life.
How would it look, within the table, if a license that expired was renewed?
Can it be done when generating the board (table type)? Must it be done by set analysis? It would be very useful to see examples of similar cases, if they exist.
Sorting my data by User license and Orde date descending
The first record for each User license is the last available license
Any subsequent records for that User license are licenses which were renewed (not considering any grace periods or other aspects I can imagine in such case)
If Today()<Expiration date then this is a valid license.
If Expiration date is less then, say, 30 days from now, this is available for renewal
Sorting my data by User license and Orde date descending
The first record for each User license is the last available license
Any subsequent records for that User license are licenses which were renewed (not considering any grace periods or other aspects I can imagine in such case)
If Today()<Expiration date then this is a valid license.
If Expiration date is less then, say, 30 days from now, this is available for renewal
.png "Luminary Alumni"){kind=icon}
