Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
May be this
=Only({<Date = {"$(=Max(Date))"}>} Percentage)
Works perfect 🙂