topic Re: Bar chart challenge in QlikView

Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 08:02:48 GMT

Hello,

I tried to create the following graph without success,

if anyone can help me it would be nice,

I have a dimension with the values A, B, C. ..

each value belongs to a group 1,2, ...

I have one simple expression: count (x)

1 C

2 H

....

I want to show the average of A, B, C. .. group by 1.2,...

each time as shown in the second graphics

the objective is to merge the two graphs

Thanks for your help

Djallel SADKI

Re: Bar chart challenge

kaushiknsolanki — Tue, 21 Jun 2011 08:45:25 GMT

Hi,

Hope this is what you want.

Find the attachment.

Regards,

Kaushik Solanki

Re: Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 08:56:54 GMT

Thank you for helping,

in the bar chart i want to display the "count" of the fields too, before each avg,

if you have an idea

Regards,

Djallel SADKI

Re: Bar chart challenge

kaushiknsolanki — Tue, 21 Jun 2011 09:09:04 GMT

Hi,

You can add one more dimention called "field" in the example.

Have a look at the example.

Regards,

Kaushik Solanki

Re: Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 09:27:22 GMT

Hi,

okay, thanks

in your exemple the avg for each group is absent,

have a look at my exemple

Regards,

Djallel SADKI

Re: Bar chart challenge

kaushiknsolanki — Tue, 21 Jun 2011 09:37:04 GMT

Hi,

Can you please provide me the qvw file with data.

Regards,

Kaushik Solanki

Re: Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 09:43:26 GMT

I'll do in a few minutes

Re: Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 11:49:37 GMT

I'm sorry but i can't provide you the qvw

Re: Bar chart challenge

kaushiknsolanki — Tue, 21 Jun 2011 11:55:54 GMT

Hi,

Its ok i understand,

Then please explain me in detail what you want and how you want. with an example.

Regards,

Kaushik Solanki

Re: Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 12:24:51 GMT

ok no problem,

- I have a graph that has dimension pdv_libellé (Buffalo,Courtepaille....

- my expression is count(distinct prestation_id), which counts the number of service

- the graph has a sort with the following expression :

Match(pdv_type_restauration_global,'Grill','A la française','Thématique','Hôtelier','FastFood','Pâtes')

which includes the point of sale by type of restoration.

I want to get the number of services per block that is done,

the problem is to introduce a bar that displays the average

here's an example :

excuse my English

Regards,

Djallel SADKI

Re: Bar chart challenge

kaushiknsolanki — Tue, 21 Jun 2011 12:35:50 GMT

Hi,

You mean to say that you want a extra bar which shows the avg.

Regards,

Kaushik Solanki

Re: Bar chart challenge

Tue, 21 Jun 2011 12:38:31 GMT

Try this

Re: Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 12:43:14 GMT

yes , an extra bar which shows the avg,

in my example I should have 6 bars

thanks

Re: Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 12:49:45 GMT

Hi,

thank you for helping ,

but what i want is to display the avg bars

Regards,

Djallel SADKI

Re: Bar chart challenge

kaushiknsolanki — Tue, 21 Jun 2011 13:00:24 GMT

Hi,

Its not possible to have count by pdv_libellé dimension and avg by group dimension in same barchart.

You can have different charts for that.

Regards,

Kaushik Solanki

Re: Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 13:05:21 GMT

Thank you,

that's what I did, two different charts

Regards,

Djallel SADKI

Re: Bar chart challenge

Tue, 21 Jun 2011 13:38:53 GMT

You can use a pivot table and demonstrate the expression with a linear gauge

Re: Bar chart challenge

djallelsadki — Tue, 21 Jun 2011 13:41:15 GMT

I will propose it.

thank you

Re: Bar chart challenge

gainkarthi — Fri, 22 Feb 2013 07:12:09 GMT

I want to show values on data points of the linear chart inside pivot table. is it possible?

Re: Bar chart challenge

gainkarthi — Fri, 22 Feb 2013 07:12:28 GMT

I want to show values on data points of the linear chart inside pivot table. is it possible?