This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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.
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
View solution in original post