Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
agorski49
New Contributor

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

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:

   

IDEMAILABLE_INDICCALLABLE_INDICBAD_ADDRESS_INDIC
1YNY
2NNY
3YYN
4NNN

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

 

IDYES_NO_FLAGGROUPING
1YEMAIL
2NEMAIL
3YEMAIL
4NEMAIL
1NADD
2NADD
3YADD
4NADD
1YCALL
2YCALL
3NCALL
4NCALL

Here was the final result:

Yes_no.PNG

4 Replies

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

Hi,

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

Regards,

Kaushik Solanki

agorski49
New Contributor

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

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

rahulpawarb
Valued Contributor III

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

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

agorski49
New Contributor

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

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?

IDEMAILABLE_INDICCALLABLE_INDICBAD_ADDRESS_INDIC
1YNY
2NNY
3YYN
4NNN