Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
sangeeth8787
New Contributor III

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 III

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 III

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