topic Re: Display Multiple Names in a Bar Graph Column in QlikView

Display Multiple Names in a Bar Graph Column

Wed, 12 Aug 2015 10:26:46 GMT

Hi,

I have the following data, and I need to create a Bar Graph.

I want to display the number of Assets raised per day. So in this example it would be 2 on the 10th, 2 on the 11th, and 4 on the 12th.

That part is fine. But I also want to break down each column into a respective team. So for example, the bar graph column for the 12th would show the number of Assets raised to be 4, with 2 from TEAM 1, 1 from both TEAM 2 / TEAM 3, each in a different colour.

Asset	Team	Date
ABC	TEAM 1	10/08/2015
XYZ	TEAM 2	10/08/2015
123	TEAM 3	11/08/2015
456	TEAM 1	11/08/2015
789	TEAM 1	12/08/2015
ABC	TEAM 2	12/08/2015
XYZ	TEAM 3	12/08/2015
123	TEAM 1	12/08/2015

Any help would be much appreciated.

Thanks!

Tristan

Re: Display Multiple Names in a Bar Graph Column

sunny_talwar — Wed, 12 Aug 2015 10:34:27 GMT

May be this:

Add Date as your first dimension and Team as your second dimension and do count(Asset) as Expression.

Re: Display Multiple Names in a Bar Graph Column

awhitfield — Wed, 12 Aug 2015 10:37:32 GMT

Hi Tristan,

PFA example.

HTH - Andy

Re: Display Multiple Names in a Bar Graph Column

sunny_talwar — Wed, 12 Aug 2015 10:37:55 GMT

This?

Re: Display Multiple Names in a Bar Graph Column

Wed, 12 Aug 2015 10:41:58 GMT

Check attachment is it what you want ?

Re: Display Multiple Names in a Bar Graph Column

Wed, 12 Aug 2015 10:57:09 GMT

Hi thanks for the examples, they're really helpful. Not 100% what I was after but they'll all still come in useful.

Much appreciated!

Re: Display Multiple Names in a Bar Graph Column

Wed, 12 Aug 2015 10:58:16 GMT

Hi Andrew, thanks very much, spot on with Sunny's above!

Cheers

Tristan

Re: Display Multiple Names in a Bar Graph Column

Wed, 12 Aug 2015 11:02:05 GMT

Thank you Sunny, that's perfect!

Kind regards,

Tristan