topic Re: Subtotal sorting problem in QlikView

Subtotal sorting problem

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

Dear Champions

Could you please help me with the below issue? Please find enclosed the QV file and Excel table. As per the below table i need the QV report as per table mentioned on the right side. The subtotal is coming as correctly but the sorting is the difference. Example for the first subtotal 2302 the line for 300 is coming below the subtotal. Please support

Re: Subtotal sorting problem

Anil_Babu_Samineni — Sun, 12 Aug 2018 07:06:47 GMT

Try this?

Match(Heading_Subtotal,'1.Profit for the year' ,'2.Depreciation','OPERATING ACTIVITIES',

'3.Amortization', '4.Provision-doubtful debts', 'CHANGES IN WORKING CAPITAL',

'5.Provision-slow moving inventories', '6.Provision-employees terminal benefits Nett', 'INVESTING ACTIVITIES', '7.Accounts receivables-Trade', '8.Prepayment and other receivables','test','OTH','FINANCING ACTIVITIES')

Re: Subtotal sorting problem

shamsu_mk — Mon, 13 Aug 2018 10:43:16 GMT

Thank you. It worked well.

If I want to have a cumulative total of all subtotal, what is the easiest way?

As mentioned below I want to have the additional subtotal as mentioned in red colour

Re: Subtotal sorting problem

Anil_Babu_Samineni — Wed, 15 Aug 2018 10:07:28 GMT

Add same values in Excel and do same as earlier. And, Additional we can use BG color to make red for Sub total.