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 for collaboration related to QlikView App Development.
I have the following table:
And the following script:
NPSSegments: LOAD FirstSortedValue(NPSSegment,-ActivityDate) as NPSSegmentPre, //avg(round(NPSScore)) as AvgNPSScore, ContactID Resident NPSPreload Where Wave = '0' Group By ContactID;
For ContactID A, there is no value. For B & C, there is.
The issue I'm having is with the ContactID A.
How can I make the script "pick" one (the latest based on the sorting of the load script) when the activity date is the same?
Now it's just returning nothing.
As always, any help is greatly appreciated!
FirstSortedValue(DISTINCT NPSSegment,-ActivityDate) as NPSSegmentPre,
View solution in original post
It worked, thanks!
One more thought on this though:
What if one contact has 2 different values on the same day. Which one will it pick? And will it produce the same "issue"?
It will pick on of them randomly. But is there a preference to what should be picked?