Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Any one help to calculate NetOpen.
Regards,
Subba Reddy.
Please provide the sample data and also logic to calculate the Netopen
Hi Subba, can you provide more detail about what you are looking for? Maybe a qvw file sample?
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
Please find the sample data
NetOpen(Jan16)=Open(Jan16)+Open(Dec15)-Close(Jan16)
may be this will help