Value per max date

[kprotrka]

I want to show the values(string values) per max date grouped by ID.

For example:

ID       DATE                            CLUSTER

1           01.01.2020                     A

1            01.01.2018                    B

1          01.01.2017                       B

I would like to have the following results:

ID       DATE                            CLUSTER

1           01.01.2020                     A

1            01.01.2018                    A

1          01.01.2017                       A

I want to have just one cluster from the max date per ID.

[Kushal_Chawda]

@kprotrka  probably you  need unqualify statement before you do any further join on Statistik table. Hence, in Qlik-Order By tab in script, you can put unqualify * ; in the end

If this still not working then you may need to debug where the problem is by executing script step by step as I won't be able to run and identify where the issue is. But, idea is that max_date column name should be same as original date column.

[kprotrka]

@Kushal_Chawda ok...try to do it now. Last question: i have in one field values like duration in seconds. For example 1410,355...and so on....i have a lot of those values. I would like to show those numbers in minutes. So when i divide those numbers with 60 i get the new results like 3,3 and so on...decimal numbers...now would like to show that in 'mm:ss' format.

[Kushal_Chawda]

@kprotrka  try below

interval(Seconds/86400,'hh:mm')

[kprotrka]

it worked...thanks 🙂