topic Re: Bar graph with 2 dimesions (Region, Country) in QlikView

Bar graph with 2 dimesions (Region, Country)

Deepak13 — Sat, 16 Nov 2024 18:26:11 GMT

Hello All

I am trying to create a bar graph where region(EMEA,APAC,Americas, etc) is our primary dimension and countries is the secondary dimension. I have added a dummy dimension so that both region and their countries are on x-axis. The issue is that the graph is not properly showing countries under every region as shown in the screenshot below. eg. Hong Kong doesn't fall under EMEA region but its showing in the graph under EMEA.

Re: Bar graph with 2 dimesions (Region, Country)

raji6763 — Wed, 01 Jul 2020 11:06:54 GMT

hi deepak,

better you can visualize your dimension as a

drill down
cyclic group

It would be more interactive to you

regards,

raji

Re: Bar graph with 2 dimesions (Region, Country)

basav — Thu, 02 Jul 2020 06:49:34 GMT

Hi Deepak,

See if block chart comes to your rescue on this. Please find the visualization below, I am sure with some coloring trick, we can make it look better.

Also @raji6763 solution would work too.

cheers,

Basav

Re: Bar graph with 2 dimesions (Region, Country)

raji6763 — Thu, 02 Jul 2020 07:09:51 GMT

hi,

this chart will occupy more space in your sheet

regards,

raji

Re: Bar graph with 2 dimesions (Region, Country)

Deepak13 — Mon, 06 Jul 2020 15:06:22 GMT

Thanks for the response @raji6763

I did suggest the user for a cyclic button that cycles between the Regions, but they want it all countries and regions on one bar graph. We have agreed to go with the block chart.

Regards

Deepak

Re: Bar graph with 2 dimesions (Region, Country)

Deepak13 — Mon, 06 Jul 2020 15:07:48 GMT

Thanks @basav for your response.

Users seem to be happy with the block chart 🙂

Re: Bar graph with 2 dimesions (Region, Country)

basav — Mon, 06 Jul 2020 15:30:19 GMT

Hi Deepak,

I am just glad my suggestion helped you.

cheers,

Basav