topic HOW TO DRAW LINES IN A CHART?? in QlikView

HOW TO DRAW LINES IN A CHART??

Fri, 01 Apr 2011 09:24:59 GMT

Hey guys! I gotta problem!

I have a bar chart, with various data, and values.

I need to find the average, and have a line cross the chart named as AVERAGE.

1) bar chart with data

2)need to calculate average of the data values,

3) draw a line across the bar chart which represents the AVERAGE value.

Can this be done ?

Thanks in advance! ( i am sorry, i do not have a qlikview file for this), could you pass me a sample ?)

HOW TO DRAW LINES IN A CHART??

Fri, 01 Apr 2011 09:33:48 GMT

I'm not sure how to name the line Average, but in the Properties-> Expressions check trendlines average box and the show equation box.

Hope this helps.

HOW TO DRAW LINES IN A CHART??

Fri, 01 Apr 2011 09:37:58 GMT

Alternatively, you can show the average value (if you have worked out the expression) as a reference line in the Presentation tab.

HOW TO DRAW LINES IN A CHART??

IAMDV — Fri, 01 Apr 2011 09:40:37 GMT

Cheenu - I did exactly the same and I could also name the reference line. This should be the simplest solution.

Cheers - DV

HOW TO DRAW LINES IN A CHART??

Fri, 01 Apr 2011 09:43:34 GMT

Trend lines is a good option, however, you don't seem to have control over the colour of the line. Reference lines allows you to state the colour of the line, put a Label to it and attach a tick box in Show Label in Chart, which will show the label itslef in the chart object.

I guess that's the specs you are looking for.

HOW TO DRAW LINES IN A CHART??

Fri, 01 Apr 2011 09:52:32 GMT

Hi Deepak,

Where did you find the label for the reference line, I can't find the label on any of the tabs (am I going blind)? Or did you put a text object on top of the chart?

HOW TO DRAW LINES IN A CHART??

Fri, 01 Apr 2011 09:53:29 GMT

Sorry Deepak,

Confused. Thought you were referring to the trend line.

HOW TO DRAW LINES IN A CHART??

Tue, 05 Apr 2011 02:13:39 GMT

Hi guys! i am not really sure about the Reference line thing!

I can get how you did the average, with the add solution thing. i did that too, but in my chart, the average line becomes something like ( Y=143).

I think that is the average value, but i'm not sure how to go about getting that.

And as for the reference line thing, how do you add the expression for the solution, or more likely, What is the expression for the solution ?

Any pointers? THanks! 😄

HOW TO DRAW LINES IN A CHART??

IAMDV — Tue, 05 Apr 2011 09:22:14 GMT

Please can you post the QV document with sample data. We can have a look...

Cheers - DV

HOW TO DRAW LINES IN A CHART??

gauravkhare — Tue, 05 Apr 2011 10:25:57 GMT

Hi Guys,

you need to add an expression by clicking on the ADD button. Over there you need to write the expression for average.

Make sure your are making a bar or a combo chart. After you have added the expression, select LINE from the Display Options. Now QlikView makes a line for you. Now if you want to change the color of the line then go to COLORS tab and click on the color representating your line, Now to change the color of the line just click on that particular color and then select from the given options as you want to go for one color, two color or solid....Then click on the base color tab and select the color of your choice and afetr applying the settings you'll find the color of your average line has changed to your desirous color.

HOW TO DRAW LINES IN A CHART??

gauravkhare — Tue, 05 Apr 2011 10:27:44 GMT

kindly post a sample data application and i will be making it for you.

HOW TO DRAW LINES IN A CHART??

Wed, 06 Apr 2011 03:38:41 GMT

HI FRIENDS! SORRY FOR THE LATE LATE POST!!!!

ANYWAYS, THIS IS A SAMPLE DATA. THERE ARE AROUND 15 PRODUCTS INSIDE, AND A BOX CHART, THERE IS A LINE THERE WHICH IS Y=107.26,

I'M GUESSING THAT IS THE AVERAGE LINE?

HOW TO DRAW LINES IN A CHART??

IAMDV — Wed, 06 Apr 2011 09:43:24 GMT

Dear Nathanael Nilesh Raj,

Yes, you are right. That is the average line. I had attached 2 images for your reference. I hope this helps.

Please let me know what is the actual issue?

Cheers - DV

HOW TO DRAW LINES IN A CHART??

Wed, 06 Apr 2011 09:52:43 GMT

Hi Deepak! Thanks for the images!!

Okay, You know the equation thing, Y=107.26,

Is there anyway for the Y to be equated to a variable called AVERAGE ?

So that, the equation of the line is, Average = 107.26

Basically, I just want the Y to be replaced by Average.

Thanks =]

HOW TO DRAW LINES IN A CHART??

IAMDV — Wed, 06 Apr 2011 10:11:42 GMT

Here you go... Please follow the steps shown in the below image.

Also please mark the post answered if this is what you need 🙂

HOW TO DRAW LINES IN A CHART??

IAMDV — Wed, 06 Apr 2011 10:17:24 GMT

Also, if you want the same using the variable. Please create a variable overiew window and then provide the expression in the Value field under Variable Overiew window. And you can call the same variable like this...

=$(vAveragePrice)

instead of the Avg(PRICE) expression. I hope this makes sense to you. If not please shout and I'll try to explain further.

Cheers- DV

HOW TO DRAW LINES IN A CHART??

Thu, 07 Apr 2011 03:22:49 GMT

Hi! Thanks for the advice! it worked!!!

But i think there's a problem!

It can be changed to Average! but when i did it, i couldn't see the value!

Is there any way to get the value?

Like i asked for, Change the Y value to be average, so that it might read like Average = 20,

But right now, its only Average!

HOW TO DRAW LINES IN A CHART??

IAMDV — Thu, 07 Apr 2011 09:25:48 GMT

I am glad that it worked for you. If you wanted to add the value after the word Averge. Please use this expression in step 4 from above image.

='Average ' & Avg(PRICE)

I hope this is what you need.

Cheers - DV