topic Scale in QlikView

Scale

emteam162 — Mon, 07 Jan 2013 15:49:59 GMT

Hi,

I have this data

Month	2011	2010
Janv	609 kg	958 kg
Fev	476 kg	994 kg
Mar	366 kg	860 kg
Avril	80 kg	731 kg
Mai	308 kg	832 kg
Juin	588 kg	698 kg
Juil	431 kg	485 kg
Aout	303 kg	540 kg
Sept	374 kg	503 kg
Oct	535 kg	1,075 T
Nov	422 kg	766 kg
Dec	456 kg	491 kg

and i want have the bar chart but i have issue with scale (with T is TONNE )

see attache please.

Any idea to solve this

Many thanks

Emteam

Re: Scale

nagaiank — Mon, 07 Jan 2013 15:55:50 GMT

I presume that you are loading the data in Qlikview as number along with the unit of measure. Try convert Tonne into Kg at load time and display the numeric data on the chart.

Hope this helps.

Re: Scale

emteam162 — Mon, 07 Jan 2013 16:05:00 GMT

Hi,

Thank you for anwser.

I am loading the data without Unit but the default unit is KG.

My client want to convert data kg into Tonne but if sum(data) are > 1000 i will diplay tonne if sum(data) < 1000 then i display Kg as unit

If you see my first attached my graph dosen't correct

Best Regards,

Emteam

Re: Scale

emteam162 — Mon, 07 Jan 2013 17:08:25 GMT

Hi,

Any idea???

Thanks

Re: Scale

Mon, 07 Jan 2013 17:35:37 GMT

I believe you are loading two fields into the app. First with everything converted to KG and other one with string formats codes (1T, 100 Kg etc). In that case you can create a chart and write and expression in Sort tab of properties. Something like Sum(FirstField) should give you correct sorting.

Remeber to select the dimension and promote it to first one in the sorting

Go to properties>Sort tab>(select the check box for expression)> then write the expression that you want for sorting..

Re: Scale

Gysbert_Wassenaar — Mon, 07 Jan 2013 17:35:44 GMT

Try using the dual function:

dual(if(sum(data)>1000,num(sum(data)/1000,'#,###.00 T'),num(sum(data),'#,###0 Kg')),sum(data))

Re: Scale

emteam162 — Tue, 08 Jan 2013 08:54:09 GMT

Hi Gysbert,

Your solution is working

Many thanks for your help

Please, can you explain me the dual function ?

Best Regards,

Emteam