topic Re: How best to build a stacked bar chart from this data? in App Development

How best to build a stacked bar chart from this data?

Anonymous — Fri, 21 Apr 2017 16:26:34 GMT

I currently have indicators across 3 different fields and want to look at the best way to build a stacked bar chart from this data. More specifically I want to understand if transforming the data I pull back is the only option or is there a way to solve this in Qlik charting.

Here is the data in the database format:

ID	EMAILABLE_INDIC	CALLABLE_INDIC	BAD_ADDRESS_INDIC
1	Y	N	Y
2	N	N	Y
3	Y	Y	N
4	N	N	N

Here is what I transformed it to in the data load script to load into the stacked bar chart:

ID	YES_NO_FLAG	GROUPING
1	Y	EMAIL
2	N	EMAIL
3	Y	EMAIL
4	N	EMAIL
1	N	ADD
2	N	ADD
3	Y	ADD
4	N	ADD
1	Y	CALL
2	Y	CALL
3	N	CALL
4	N	CALL

Here was the final result:

Re: How best to build a stacked bar chart from this data?

kaushiknsolanki — Fri, 21 Apr 2017 17:40:35 GMT

Hi,

The output image is not visible, can you upload again?

Regards,

Kaushik Solanki

Re: How best to build a stacked bar chart from this data?

Anonymous — Fri, 21 Apr 2017 18:05:12 GMT

I've added it as an attachment hopefully that works.

Re: How best to build a stacked bar chart from this data?

rahulpawarb — Fri, 21 Apr 2017 18:30:32 GMT

Hello Alex,

Hope that you are keeping well!

You can create two measures:

1. Yes = Count({<YES_NO_FLAG={'Y'}>}YES_NO_FLAG)

2. No = Count({<YES_NO_FLAG={'N'}>}YES_NO_FLAG)

Post that you can change the presentation settings of the bar chart to make it stacked bar chart.

Refer attached application.

Regards!

Rahul

Re: How best to build a stacked bar chart from this data?

Anonymous — Fri, 21 Apr 2017 18:33:52 GMT

Hi Rahul,

I did that in the second example. What I'm really wondering is there another way to take the data from the first table, and without transforming it create the same thing?

ID	EMAILABLE_INDIC	CALLABLE_INDIC	BAD_ADDRESS_INDIC
1	Y	N	Y
2	N	N	Y
3	Y	Y	N
4	N	N	N