topic Re: Color coded Stacked bar chart in Qliksense in QlikView

Color coded Stacked bar chart in Qliksense

BI_Dev — Wed, 25 Nov 2020 16:16:04 GMT

I have data as below

ID Score1 Score2

1 36 32

2 32 24

3 22 12

4 29 30

I want to create a stacked bar chart for each expression and color code that stack based on the color code in Qliksense.

Dimension:

Measure:

Exp1 - Sum(Score1)

Color Code

if(Score1 >0 and Score1 <20,red(),

if(Score1 >20 and Score1 <35,yellow(),green()))

Exp2 - Sum(Score2)

Color Code

if(Score2 >0 and Score2 <20,red(),

if(Score2 >20 and Score2 <35,yellow(),green()))

Thank you very much.

Re: Color coded Stacked bar chart in Qliksense

Anil_Babu_Samineni — Tue, 21 Nov 2017 14:00:46 GMT

What are you getting currently?

Re: Color coded Stacked bar chart in Qliksense

BI_Dev — Tue, 21 Nov 2017 14:20:30 GMT

PFA QVF.

Here ID 1 - Score 1 should be red

ID 3 - Score1 should be red

ID 4 - Score 1 should be yellow...

Re: Color coded Stacked bar chart in Qliksense

Anil_Babu_Samineni — Tue, 21 Nov 2017 15:30:50 GMT

Are you expecting this?

Re: Color coded Stacked bar chart in Qliksense

BI_Dev — Tue, 21 Nov 2017 15:33:14 GMT

Can I see the QVF ? not sure what blue is for 2 as it should be yellow...

Re: Color coded Stacked bar chart in Qliksense

Anil_Babu_Samineni — Tue, 21 Nov 2017 15:36:09 GMT

This? PFA

Re: Color coded Stacked bar chart in Qliksense

BI_Dev — Tue, 21 Nov 2017 15:37:28 GMT

yup...dont see attachment...Thank you very mcuh..

Re: Color coded Stacked bar chart in Qliksense

BI_Dev — Tue, 21 Nov 2017 16:28:31 GMT

Can you please send the attachment ?

Re: Color coded Stacked bar chart in Qliksense

Anil_Babu_Samineni — Tue, 21 Nov 2017 16:46:59 GMT

I apologies for that? Here are the 2 versions. Because, In QV we have direct facility but QS, We need to work around

Re: Color coded Stacked bar chart in Qliksense

Anil_Babu_Samineni — Sat, 25 Nov 2017 10:45:08 GMT

If you solve your issue, Please do it your job and if still not yet solved please free to ask Qlik Community Tip: Marking Replies as Correct or Helpful