Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

Category help!

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:

Cost.PNG

Thanks,

AS

3 Replies
micheledenardi
Specialist II
Specialist II

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
micheledenardi
Specialist II
Specialist II

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

2018-05-08 11_55_27-Modifica Script [M__test.qvw_].png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
amit_saini
Master III
Master III
Author

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,

AS