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

How to show values in line chart?

Wed, 27 Mar 2013 14:53:08 GMT

Hi Team,

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

if(sum(Amount)>=1000000

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

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

I applied above formula ,but the trend line shows bleow

Millions shows down trend and Thousand shows up trend

Thanks

Re: How to show values in line chart?

Fri, 29 Mar 2013 04:36:45 GMT

Hi Team,

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

if(sum(Amount)>=1000000

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

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

I applied above formula ,but the trend line shows bleow

Millions shows down trend and Thousand shows up trend

Thanks

Re: How to show values in line chart?

Fri, 29 Mar 2013 04:56:49 GMT

That is because of Y axis. You need to fix the Y axis points.

Re: How to show values in line chart?

Fri, 29 Mar 2013 05:02:48 GMT

Go to the Number tab and set the below properties for each of the expression. Hope this helps

Number Format Setting = Integer.

In the Thousand Symbol input field enter x Thousand.

In the Million Symbol box enter x Million.

In the Billion Symbol box enter, you guessed it, x Billion.

Re: How to show values in line chart?

Fri, 29 Mar 2013 05:10:15 GMT

Hi Streak

Its not working

Re: How to show values in line chart?

Fri, 29 Mar 2013 05:18:58 GMT

Can you post sample qvw ?

Re: How to show values in line chart?

Fri, 29 Mar 2013 05:29:18 GMT

Hi ,

Please find the qvd file

Re: How to show values in line chart?

kaushiknsolanki — Fri, 29 Mar 2013 06:03:26 GMT

Hi,

Have a look at the attached example.

Regards,

Kaushik Solanki

Re: How to show values in line chart?

Fri, 29 Mar 2013 06:51:22 GMT

Thanks, Kaushik

Problem Solved

Re: How to show values in line chart?

nizamsha — Fri, 29 Mar 2013 06:58:25 GMT

write 2 expression

first one

sum(access)

second one

if(sum(Access)>=1000000,

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

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

for first one enable line and symbol check box

for the second one enable values on data poin it will give the output what u want

Re: How to show values in line chart?

kaushiknsolanki — Fri, 29 Mar 2013 07:01:44 GMT

Hi,

Please close the Post by clicking correct answer.

Regards,

Kaushik Solanki

Re: How to show values in line chart?

Wed, 10 Apr 2013 14:47:15 GMT

=IF([Student Version] = "no",
[TOTAL SEATS BILLED] * INDEX(SeatSalesFactors[Factor], MATCH([Market] & ":" & [Segment], SeatSalesFactors[Joined Key], 0)),
[TOTAL SEATS BILLED])

if((segement='Post-Secondary') and (market='Emerging') then ((([TOTAL SEATS BILLED])*75)/100)*18),

elseif((segement='Post-Secondary') and (market='Mature') then ((([TOTAL SEATS BILLED])*75)/100)*3),

elseif((segement='Secondary') and (market='Emerging') then ((([TOTAL SEATS BILLED])*75)/100)*15),

elseif((segement='Secondary') and (market='Mature') then ((([TOTAL SEATS BILLED])*75)/100)*5)

else

end if