How to translate qlikview the following expression (min(Txdn_Dt) Value)

[sangeeth8787]

Hi ,

I have month or date filters, If user choose month filter alone, I want to return the results of that month first date result as Opening Balance.

like 

Eg:

User Chooses  month : Jan

Min(Date) --- 1st Jan, the opening Balance is $300

So I am looking to translate following logic into qlikview syntax

Date(min(Txn_Date), Balance ------- > Balance of the first date for selected month. 

I really appreciate if any could give any ideas how to this.

Thank you

Sangeeth

[sunny_talwar · Accepted solution]

May be this

FirstSortedValue(Balance, Txn_Date)

[sangeeth8787]

Hi Sunny,

I am glad for your reply, this works perfect for my scenario. you are star.

[sangeeth8787]

Hi,

If we want to do same thing for (max(Txdn_Dt) Value), is it just use same function by ordering desc.