topic Re: Opening and Closing Balance Issue in QlikView

Opening and Closing Balance Issue

Karim_Khan — Wed, 25 Nov 2020 16:16:04 GMT

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,

kaushiknsolanki — Thu, 17 Nov 2016 13:07:02 GMT

Hi,

Check below posts.

Regards,

Kaushik Solanki

Karim_Khan — Thu, 17 Nov 2016 13:11:04 GMT

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

stabben23 — Thu, 17 Nov 2016 13:51:18 GMT

Hi,

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

Karim_Khan — Thu, 17 Nov 2016 15:08:42 GMT

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 — Thu, 17 Nov 2016 15:58:05 GMT

Hi,

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