Opening and Closing Balance Issue

[Karim_Khan]

Hi Team,

    I have tried many logic i got some idea but at the end it got failed.pfais the sample o/p

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.

Regards,

KK

[kaushiknsolanki]

Hi,

Check below posts.

https://community.qlikview.com/thread/126403

Simple calculate open and closing balances

Regards,

Kaushik Solanki

[Karim_Khan]

Tnx kaushik but i donot have defined data records i need to create the colum at script level so i got stuck

[stabben23]

Hi,

if you just want to do this in GUI, this is one way.

[Karim_Khan]

Hi Stefan,

    Tnx for ur help.I got it but one confusion the code which i have used it is creating dimension and i wanted to apply

YTD and MTD wala logic will it work on it if yes then how can we use dimesnion in SET Analysis?

[stabben23]

Hi,

can you show som sample how you want this? II can not fully understand you right now.