Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Expression help please.

I have the file attached and QVW.

I want to show the phase which has Yes based on the latest Phaseno.

Ex: Prj - 151 should show Const and Prj - 152 should show Due.

How can I do this ?

Thank you,

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be this?

FirstSortedValue({<YesNo = {'Yes'}>} Phase, -PhaseNo)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

May be this?

FirstSortedValue({<YesNo = {'Yes'}>} Phase, -PhaseNo)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
apthansh
Creator
Creator
Author

Awsomenesssss.Thank you very much.