Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have the following table:
Date("Start Date") as "Start Date",
(ooxml, embedded labels, table is Sheet8);
[Person ID] as Person,
FirstSortedValue(Status,-[Start Date],1) as Status_Tmp
Group By [Person ID];
Then I get this null values and I cannot understand why.
Go to Solution.
Solved! thanks to this: FirstSortedValue issue | Qlik Community
I just added a distinct after the function FirstSortedValue
FirstSortedValue(distinct Status,-[Start Date],1) as Status_Tmp