Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

srishsum2017
Contributor

Employee Hired Data

Hi all,

My Data is this-

 

YearHiredM0M1M2M3M4M5M6M7M8M9M10M11M12
Apr-2016           399            397            378            344            318            304            291            278            270            266            260            255            240            227
May-2016           413            407            387            359            335            315            303            287            281            269            261            259            249            237
Jun-2016           344            339            316            290            271            255            246            238            230            215            206            194            192            181
Jul-2016           394            389            375            360            338            319            304            288            276            266            254            246            239            234
Aug-2016           425            415            399            373            349            333            311            299            289            278            264            258            247                -  
Sep-2016           426            419            398            369            339            318            306            287            269            261            254            249                -                  -  
Oct-2016           356            349            334            324            297            284            269            250            237            226            221                -                  -                  -  
Nov-2016           326            321            312            289            275            252            235            220            217            207                -                  -                  -                  -  
Dec-2016           327            324            314            292            270            252            236            224            216                -                  -                  -                  -                  -  
Jan-2017           338            334            321            299            274            251            241            230                -                  -                  -                  -                  -                  -  
Feb-2017           357            350            339            318            299            286            273                -                  -                  -                  -                  -                  -                  -  
Mar-2017           429            420            405            383            363            351                -                  -                  -                  -                  -                  -                  -                  -  

I need output-

 

    

YearHiredM0M1M2M3M4M5M6M7M8M9M10M11M12
Total4534446442784000372835203015260122851988172014611167879
Apr-2016         399           397          378          344          318          304          291          278          270          266          260          255          240          227
May-2016         413           407          387          359          335          315          303          287          281          269          261          259          249          237
Jun-2016         344           339          316          290          271          255          246          238          230          215          206          194          192          181
Jul-2016         394           389          375          360          338          319          304          288          276          266          254          246          239          234
Aug-2016         425           415          399          373          349          333          311          299          289          278          264          258          247             -  
Sep-2016         426           419          398          369          339          318          306          287          269          261          254          249             -               -  
Oct-2016         356           349          334          324          297          284          269          250          237          226          221             -               -               -  
Nov-2016         326           321          312          289          275          252          235          220          217          207             -               -               -               -  
Dec-2016         327           324          314          292          270          252          236          224          216             -               -               -               -               -  
Jan-2017         338           334          321          299          274          251          241          230             -               -               -               -               -               -  
Feb-2017         357           350          339          318          299          286          273             -               -               -               -               -               -               -  
Mar-2017         429           420          405          383          363          351             -               -               -               -               -               -               -               -  
6 Replies
agigliotti
Honored Contributor II

Re: Employee Hired Data

you can simple use grand total of chart object.

kenphamvn
Contributor III

Re: Employee Hired Data

Hi

Please see attached file

Regards

srishsum2017
Contributor

Re: Employee Hired Data

I used but its gives wrong output-

it gives

 

YearHiredM0M1M2M3M4M5M6M7M8M9M10M11M12
Total45344464427840003728352033663225313930582997295929142873
Apr-2016           399            397            378            344            318            304            291            278            270            266            260            255            240            227
May-2016           413            407            387            359            335            315            303            287            281            269            261            259            249            237
Jun-2016           344            339            316            290            271            255            246            238            230            215            206            194            192            181
Jul-2016           394            389            375            360            338            319            304            288            276            266            254            246            239            234
Aug-2016           425            415            399            373            349            333            311            299            289            278            264            258            247                -  
Sep-2016           426            419            398            369            339            318            306            287            269            261            254            249                -                  -  
Oct-2016           356            349            334            324            297            284            269            250            237            226            221                -                  -                  -  
Nov-2016           326            321            312            289            275            252            235            220            217            207                -                  -                  -                  -  
Dec-2016           327            324            314            292            270            252            236            224            216                -                  -                  -                  -                  -  
Jan-2017           338            334            321            299            274            251            241            230                -                  -                  -                  -                  -                  -  
Feb-2017           357            350            339            318            299            286            273                -                  -                  -                  -                  -                  -                  -  
Mar-2017           429            420            405            383            363            351                -                  -                  -                  -                  -                  -                  -                  -  

but i want-

    

YearHiredM0M1M2M3M4M5M6M7M8M9M10M11M12
Total4534446442784000372835203015260122851988172014611167879
Apr-2016         399           397          378          344          318          304          291          278          270          266          260          255          240          227
May-2016         413           407          387          359          335          315          303          287          281          269          261          259          249          237
Jun-2016         344           339          316          290          271          255          246          238          230          215          206          194          192          181
Jul-2016         394           389          375          360          338          319          304          288          276          266          254          246          239          234
Aug-2016         425           415          399          373          349          333          311          299          289          278          264          258          247             -  
Sep-2016         426           419          398          369          339          318          306          287          269          261          254          249             -               -  
Oct-2016         356           349          334          324          297          284          269          250          237          226          221             -               -               -  
Nov-2016         326           321          312          289          275          252          235          220          217          207             -               -               -               -  
Dec-2016         327           324          314          292          270          252          236          224          216             -               -               -               -               -  
Jan-2017         338           334          321          299          274          251          241          230             -               -               -               -               -               -  
Feb-2017         357           350          339          318          299          286          273             -               -               -               -               -               -               -  
Mar-2017         429           420          405          383          363          351             -               -               -               -               -               -               -               -  
agigliotti
Honored Contributor II

Re: Employee Hired Data

the problem is the null value.

replace null with 0 and it should works.

srishsum2017
Contributor

Re: Employee Hired Data

Hi This is not my solution because the values comes under the M0, M1...M12 is after the calculation

agigliotti
Honored Contributor II

Re: Employee Hired Data

ok but you can do this in your script:

LOAD

...

...

if( isnull(M0), 0, M0 ) as M0


and repeat for all your columns.