Search in a same table a renewal of a license - 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.