Opening Balance and Closing Balance Ledger Issue in MTD

[Karim_Khan]

Hi Team,

     I have tried it but unable to implement the logic into qlikview.I am using some formule but unable to execute it properly

PFA

Regards,

KK

[saimahasan]

Hi Karim

Please elaborate what is expected and where it is expected since your application has many tabs. Under which tab where are you trying to implement thi slogic??

[Karim_Khan]

Hi Saima,

    I have one request ?Pls delete my app if u have downloaded

[Anil_Babu_Samineni]

Can you share That expression? We can see what is the problem with that expression?

And, saimahasan Try To Delete ASAP. I request you to don't share on community / Colleagues(As Karim, Requested)

[Karim_Khan]

Hi Anil,

    I am using the below expression.I wanted to know how can we achoive the Stock exchange Opening Balance,Closing Balance,new and Closed sales of every day.

Openin Balance:

=COUNT({<START_DT={'<=$(vPrev2Day)'},END_DT={'>=$(vYesterday)'},FIN_YEAR_NO={$(=$(vMaxYear))},FIN_MONTH_NO={$(=$(vMaxMon))},FIN_MONTH=,MONTH=,MONTH_NO=,FIN_QUARTER=>}sales)

New Cases:

=COUNT({$<START_DT={'=$(vYesterday)'},FIN_YEAR_NO={$(=$(vMaxYear))},FIN_MONTH_NO={$(=$(vMaxMon))},FIN_MONTH=,MONTH=,MONTH_NO=,FIN_QUARTER=>}sales)

Processed:

=COUNT({$<END_DT={'=$(vYesterday)'},FIN_YEAR_NO={$(=$(vMaxYear))},FIN_MONTH_NO={$(=$(vMaxMon))},FIN_MONTH=,MONTH=,MONTH_NO=,FIN_QUARTER=>}sales)

Pending:

=COUNT({$<END_DT={'=$(vToday)'},FIN_YEAR_NO={$(=$(vMaxYear))},FIN_MONTH_NO={$(=$(vMaxMon))},FIN_MONTH=,MONTH=,MONTH_NO=,FIN_QUARTER=>}sales)

Regards,

KK

[Karim_Khan]

Any Help on this

[saimahasan]

Anil

I didnt share any app..

[Karim_Khan]

Saima,

    Sorry i ve shared some data ,for that i ve requested u to delete the same.

Any way can u guide me for above issue

[saimahasan]

Is this the same excel format you are using in your app?

[Karim_Khan]

Yes but this excel is updated one.Here the values are already define for columns Purchase and Sales

but i have to create calculated/customized column/dimension and For Opening and Closing Balance

after that i will try to impment the given application logic into my logic.