How to calculate NetOpen? - Qlik Community

Report Inappropriate Content · ‎2016-04-14

Hi Folks,

Any one help to calculate NetOpen.

Regards,

Subba Reddy.

Kushal_Chawda · ‎2016-04-14

Please provide the sample data and also logic to calculate the Netopen

clondono · ‎2016-04-14

Hi Subba, can you provide more detail about what you are looking for? Maybe a qvw file sample?

vikasmahajan · ‎2016-04-14

you can refer this https://community.qlik.com/message/5556#5556

like inventory we can calculate aging of customer , Instead of item consider customer and calculate

the outstanding like item stock and show the net balance.

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2016-04-14

Please find the sample data

NetOpen(Jan16)=Open(Jan16)+Open(Dec15)-Close(Jan16)

Kushal_Chawda · ‎2016-04-14

may be this will help

Help needed to get stock for Max day of Month