Qlik Community

Qlik Support Discussions

Discussion Board for collaboration related to Qlik Support.

Highlighted
sangeeth8787
New Contributor

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

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

 

1 Solution

Accepted Solutions

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

May be this

FirstSortedValue(Balance, Txn_Date)
3 Replies

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

May be this

FirstSortedValue(Balance, Txn_Date)
sangeeth8787
New Contributor

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

Hi Sunny,

 

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

sangeeth8787
New Contributor

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

Hi,

 

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

 

 

Community Browser