topic Re: How to show values in line chart? in QlikView

How to show values in line chart?

Tue, 26 Mar 2013 10:55:16 GMT

Hi Team,

How to show values in Million(m) foramt and thousand(k) foramts in line chart

please find the attached doc

Thanks

Re: How to show values in line chart?

Gabriel — Tue, 26 Mar 2013 11:19:11 GMT

Hi,

First thing I will do is, go to chart properties ->Number tab -> bottom right Thousand Symbol enter TH (or whatever you prefer) -> Million Symbol enter M (or whatever symbol you prefer). Then go to Expression tab then check Values on Data Points. Click OK.

Hope that helps

Regards,

Gabriel

Re: How to show values in line chart?

jagan — Tue, 26 Mar 2013 11:25:54 GMT

PFA file, hope it helps you.

Regards,

Jagan.

Re: How to show values in line chart?

Tue, 26 Mar 2013 11:58:40 GMT

Hi jagan,

Iam unable to open qvd file

could you post those steps

thanks

Re: How to show values in line chart?

Gysbert_Wassenaar — Tue, 26 Mar 2013 12:22:49 GMT

Something like this:

if(sum(Amount)>=1000000

,num(sum(Amount)/1000000,'#,##0.0 M')

,num(sum(Amount)/1000,'#,##0 K'))

Replace sum(Amount) with the expression you use now.

Re: How to show values in line chart?

jagan — Tue, 26 Mar 2013 12:36:50 GMT

Hi,

Please find attached file.

Regards,

Jagan.

Re: How to show values in line chart?

Tue, 26 Mar 2013 12:39:32 GMT

Excellent Wassennar,

Thanks

Re: How to show values in line chart?

Tue, 26 Mar 2013 13:31:42 GMT

Hi Wassennar,

I applied your formula ,but the trend line shows above

Millions shows down trend and Thousand shows up trend

Thanks