topic chart presentation in QlikView

chart presentation

ssriramin19 — Mon, 30 Mar 2015 07:11:01 GMT

I have a bar chart. Which shows 12 months of data.Thebar chart has three expressions. When a mouse is placed over any month of any expression the corresponding values is shown .

But I also have the average shown at the end of chart. When the mouse is placed over the average bar the values are not shown.What needs to be done for the values to appear in the average bar ?

For reference the bar chart has been attached herewith .

THANKS

Sriram

Re: chart presentation

ashfaq_haseeb — Mon, 30 Mar 2015 07:17:17 GMT

Hi,

Go to chart properties --> Expression tab --> Select values on data point.

Regards

ASHFAQ

Re: chart presentation

ssriramin19 — Mon, 30 Mar 2015 07:21:17 GMT

No it should not be like this. The values should appear when mouse is just placed in any of the bar chart for any month . See attached file for reference.

similar way for the average bar chart

Re: chart presentation

prieper — Mon, 30 Mar 2015 08:05:33 GMT

Chart - Properties - Expressions - Tickmark "Text as Pop-up"

HTH Peter

Re: chart presentation

ssriramin19 — Mon, 30 Mar 2015 08:13:57 GMT

no it is not appearing as needed.Refer the attachement for requrirement.

Re: chart presentation

Mon, 30 Mar 2015 08:27:40 GMT

How are you showing the averages in the chart? Is the attachment you sent from Excel or QlikView? Why don't you try adding trend lines?

Re: chart presentation

ssriramin19 — Mon, 30 Mar 2015 08:42:34 GMT

The attachement refers from the qlikview chart only .If the mouse is placed over any months then the value of each of the expression pops up .

Re: chart presentation

prieper — Mon, 30 Mar 2015 08:42:42 GMT

Then please check other settings or create the chart from scratch.

Peter

Re: chart presentation

ssriramin19 — Mon, 30 Mar 2015 08:47:52 GMT

for each of the months if the mouse is placed on the top of the bar chart the values of corresponding expression appears. but not average alone. Even If I try to create a new chart , I am unable to get the value for average.

Re: chart presentation

prieper — Mon, 30 Mar 2015 09:54:32 GMT

How do you calculate the average? Can you please post an example?

Peter

Re: chart presentation

ssriramin19 — Mon, 30 Mar 2015 10:07:01 GMT

Please refer the attached document .The average is computed as explained in the word document.