Category help!

amit_saini — Tue, 08 May 2018 09:36:22 GMT

Hi Folks,

I'm using below simple logic:

fact:

LOAD

[GuV Zeile] as Income_Statement,

if(Match([GuV Zeile],'I - Raw material','J - Other components','K - Freight-in','L - Int. delivered mat. [Germany]','M - Discounts'),'Production Material',

if(Match([GuV Zeile],'N - Direct labor'),'Direct Labour',

if(Match([GuV Zeile],'P - Contract labor'),'Contract Labor',

if(Match([GuV Zeile],'R - Indirect personnel','S - Temporary Ind. Employees','T - Other overhead'),'Overhead/Temp Emp',

if(Match([GuV Zeile],'X - thereof all other','Y - HQ allocation [Germ. & KNA]','Z - Plant to plant charging'),'Other Operating Inc/Exp',

if(Match([GuV Zeile],'F - Freight-out','G - Packaging','H - Commissions'),'Distribution',

if(Match([GuV Zeile],'Q - Energy'),'Energy',

if(Match([GuV Zeile],'U - Maintenance (material & outside)','V - Repair moulds/fin. Lines','W - Depreciation'),'Other Fixed Costs',

if(Match([GuV Zeile],'F - Freight-out',

'G - Packaging',

'I - Raw material',

'J - Other components',

'K - Freight-in',

'L - Int. delivered mat. [Germany]',

'M - Discounts',

'N - Direct labor',

'P - Contract labor',

'S - Temporary Ind. Employees',

'T - Other overhead',

'U - Maintenance (material & outside)',

'X - thereof all other',

'Z - Plant to plant charging'),'Total Cost'))))))))) as Cost_Type

FROM

....................

But no sure why "Total Cost" has not been displayed inside Cost_Type:

Thanks,

Re: Category help!

micheledenardi — Tue, 08 May 2018 09:41:38 GMT

Can you share the file PST_Version 118_23.04.2018.xlsm ?

Re: Category help!

micheledenardi — Tue, 08 May 2018 10:00:30 GMT

Because all value of "Total Cost" category are already included in previous if(match()) conditions...

Re: Category help!

amit_saini — Tue, 08 May 2018 10:52:38 GMT

Yes I know that , but looking for a way to categorize them on script side, not sure if this is possible.

As they are associated with Cost , so for time being I'm calling them different expressions as combination of Cost and Income Statement.

Regards,

topic Re: Category help! in QlikView

Category help!

Re: Category help!

Re: Category help!

Re: Category help!