Discussion board where members can learn more about Qlik Sense Advanced Authoring.
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.
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.
Go to Solution.
May be this
I am glad for your reply, this works perfect for my scenario. you are star.
If we want to do same thing for (max(Txdn_Dt) Value), is it just use same function by ordering desc.