Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
ramusubramani
New Contributor II

script

Hello

I have table like this in my datamodel

MonthTypeLEAmt
AprilCUSTOM BROKERS    (1,670,858.99)
AprilDUTY (20,790,770.96)
AprilFREIGHT INBOUND    (2,243,902.26)
AprilFREIGHT OUTBOUND (23,816,177.97)
AprilLOGISTICS OVERHEAD            (1,048.35)
AprilWAREHOUSING    (5,730,697.68)
AprilTradeUnits     4,051,269.00

i have to create another column in my datamodel it should be like this. please help us in scripting

MonthTypeLEAmtLEUnitsAmt calculation example
AprilCUSTOM BROKERS    (1,670,858.99)
AprilDUTY (20,790,770.96)
AprilFREIGHT INBOUND    (2,243,902.26)
AprilFREIGHT OUTBOUND (23,816,177.97)
AprilLOGISTICS OVERHEAD            (1,048.35)
AprilWAREHOUSING    (5,730,697.68)
AprilTradeUnits     4,051,269.00
AprilCUSTOM BROKERS/Units -0.41=-1670858.99/4051269
AprilDUTY/Units -5.13 (20,790,770.96)/4051269
AprilFREIGHT INBOUND/Units -0.55 (2,243,902.26)/4,051,269.00
AprilFREIGHT OUTBOUND/Units -5.88
AprilLOGISTICS OVERHEAD/Units 0.00
AprilWAREHOUSING/Units -1.41

Please help us in scripting

regards

ramu

Tags (1)
1 Reply
Not applicable

Re: script

Maybe...

LEFT JOIN(OriginalTable)

LOAD

Type,

LEAamt/sum(TOTAL LEAamt) as Calc

RESIDENT OriginalTable;