How to get the closing balance expression

suvechha_b — Fri, 12 Feb 2016 12:13:14 GMT

Closing Balance : Opening Balance - Remaining [order_type_desc]

Note : [order_type_desc] differs for every product and period

so for 1st product : Closing Balance = Opening Balance - (Sales,Purchase,Inventory Adjustment 711,Inventory Adjustment 651,Inventory Adjustment P33,Inventory Adjustment P32,Inventory Adjustment 702)

2nd product : Closing Balance = Opening Balance - (Sales,Purchase,Inventory Adjustment 711,Inventory Adjustment P33,Inventory Adjustment 702)

[order_type_desc] is dynamic value

Sample attached.

Re: How to get the closing balance expression

kaushiknsolanki — Fri, 12 Feb 2016 12:19:04 GMT

Hi,

See the attached file.

Regards,

Kaushik Solanki

Re: How to get the closing balance expression

suvechha_b — Fri, 12 Feb 2016 12:24:09 GMT

Hi Kaushik,

I want the same output as below

eg ,

topic How to get the closing balance expression in QlikView

How to get the closing balance expression

Re: How to get the closing balance expression

Re: How to get the closing balance expression