Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Employee
Employee

How I can show the field value ("appName") for the latest change date?

I am displaying visuals around when and by whom apps were created, reloaded, modified and imported and I want to show list "The latest app to be created" and "Latest app created took place" and show the timestamp.

I can get the timestamp for the latest creation: max([App Created Date])

However, I can't seem to get the name of that app (appName) associated with that latest creation timestamp. (This is in a single KPI measure - not in a table with dimensions.)

I have tried the several variations of the following but all return null:

firstsortedvalue(appName,-[App Created Date])

max({<[App Created Date]={"=$(=max([App Created Date]))"} >} appName)

Any ideas? Seems like this should not be so difficult.

1 Solution

Accepted Solutions
Not applicable

Re: How I can show the field value ("appName") for the latest change date?

Hi Tyler,

I think while filtering the App Created Date = max(App Created Date)in the set analysis its recognizing App Created Date as string . I have created and attached the .qvw  which has similar data as your example and solves your problem at script level by converting date into numerical value. Please take a look at the script. Hope this helps you.

Regards

2 Replies
Not applicable

Re: How I can show the field value ("appName") for the latest change date?

Hi Tyler,

I think while filtering the App Created Date = max(App Created Date)in the set analysis its recognizing App Created Date as string . I have created and attached the .qvw  which has similar data as your example and solves your problem at script level by converting date into numerical value. Please take a look at the script. Hope this helps you.

Regards

Employee
Employee

Re: How I can show the field value ("appName") for the latest change date?

Thank you HareKrishna! This is exactly the issue.  I did something similar - just using interval(now()-appDate) and sorting on that new field.