Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

djallelsadki
Contributor

Bar chart challenge

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)

    A

    B

1  C

    D

    E

    F

    G

2  H

    I

    J

    K

....

....

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

19 Replies

Re: Bar chart challenge

Hi,

    Hope this is what you want.

    Find the attachment.

Regards,

Kaushik Solanki

djallelsadki
Contributor

Re: Bar chart challenge

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

Hi,

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

     Have a look at the example.

Regards,

Kaushik Solanki

djallelsadki
Contributor

Re: Bar chart challenge

Hi,

okay, thanks

in your exemple the avg for each group is absent,avg.jpg

have a look at my exemple

Regards,

Djallel SADKI

Re: Bar chart challenge

Hi,

    Can you please provide me the qvw file with data.

Regards,

Kaushik Solanki

djallelsadki
Contributor

Re: Bar chart challenge

I'll do in a few minutes

djallelsadki
Contributor

Re: Bar chart challenge

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

Re: Bar chart challenge

Hi,

    Its ok i understand,

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

Regards,

Kaushik Solanki

djallelsadki
Contributor

Re: Bar chart challenge

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



Community Browser