HOW TO DRAW LINES IN A CHART??

[#1]

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 ?)

[gauravkhare]

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

[#3]

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?

[IAMDV]

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

[#5]

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 =]

[IAMDV · Accepted solution]

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

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

[IAMDV]

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

[#8]

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!

[IAMDV]

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