Displaying value based on condition in qlikview

[Yuva_S]

Mates,

i am very new to QlikView. i got stuck in determining the result based upon the condition.

Condition:

i need to get the percentage in QlikView text box based upon the function max(Date).

But am not successful.  Need your help.

P.S : Tried with expression =only({<Date={max(Date)}>}Percentage), but does not getting the required result.

Date	Percentage
1-Nov	95%
2-Nov	92%
3-Nov	93%
4-Nov	99%

[sunny_talwar · Accepted solution]

May be this

=Only({<Date = {"$(=Max(Date))"}>} Percentage)

[Yuva_S]

Works perfect 🙂