Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
javipower72
New Contributor II

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.

Thank you.

Labels (2)