Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
djallelsadki
Partner - Creator
Partner - Creator

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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Hope this is what you want.

    Find the attachment.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
djallelsadki
Partner - Creator
Partner - Creator
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

     Have a look at the example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
djallelsadki
Partner - Creator
Partner - Creator
Author

Hi,

okay, thanks

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

have a look at my exemple

Regards,

Djallel SADKI

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Can you please provide me the qvw file with data.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
djallelsadki
Partner - Creator
Partner - Creator
Author

I'll do in a few minutes

djallelsadki
Partner - Creator
Partner - Creator
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Its ok i understand,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
djallelsadki
Partner - Creator
Partner - Creator
Author

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