topic Re: How to make 451,033 show 451 - tutorial help in QlikView

How to make 451,033 show 451 - tutorial help

Fri, 19 Aug 2011 12:43:32 GMT

Hey Friends

In The Qlikview Tutorial, on page 70, figure 14, i see that the number at the top of each bar in the chart shows 241, 202,117 etc., whereas the Y axis value is in 1,000 $.

However, when I followed the instructions on the tutorial, I kept getting the axis right (i.e going from 0 to 250 and 1,000$ as units) yet the numbers at the top of each bar kept showing 240,781 etc.

I am attaching my tutorial qvw file, and an umage of the figure shown in the tutorial itself.

I also opened the TutorialFinal.qvw file, oddly it shows the same table I made myself.

I downloaded Qlikview and the tutorial today, so these are the latest versions.

Please help 🙂

How to make 451,033 show 451 - tutorial help

swuehl — Fri, 19 Aug 2011 13:00:11 GMT

Well, what you can do is set the symbol to '1,000 $', not the field for Thousand, in number tab.

Then devide your expression by 1000.

Regards,

Stefan

Re: How to make 451,033 show 451 - tutorial help

Fri, 19 Aug 2011 13:39:26 GMT

Replace your Expresion for this expresion:

Sum

(Sales)/1000

This Will solve your Problem.

Gretings!!

Re: How to make 451,033 show 451 - tutorial help

Sun, 21 Aug 2011 17:11:04 GMT

Hey

Thank you both. I figured rhis can solve the problem, I just wanted to make

sure I was following the tutorial properly - so i gather it's not about

chart characteristics, it's just a mistake in the tutorial.

Thank you

On Aug 19, 2011 10:34 PM, "javortiz" <qliktech@sgaur.hosted.jivesoftware.com