topic qlik sense stacked bar chart color expression in App Development

qlik sense stacked bar chart color expression

Thu, 22 Jan 2015 05:06:47 GMT

I have a stacked bar chart.my data looks like below.My stack bar contains Discussion, replies,wiki per author. I want to use blue color for Discussion, green for replies, red for wikis something like that. How do i write expression for this scenario and if i use custom expression does legend appear ?

Can you please help on this

Author Type Count

Jack DIscussion 10

Mike Discussion 20

Mike Replies 30

Roger Wiki 10

Jack Wiki 20

Jack Replies 20

Thanks

Re: qlik sense stacked bar chart color expression

Anonymous — Thu, 22 Jan 2015 05:31:07 GMT

Hi Vamsi,

Try the custom expression like "if(Type='Discussion',blue(),if(Type='Replies',Green(),Red()))"

By default when you use custom expression the legend wont appear...

If you want the legend to appear then go by the custom color by dimension - type

Hope this helps

Thanks,

Vignesh

Re: qlik sense stacked bar chart color expression

Thu, 22 Jan 2015 05:50:47 GMT

Thanks for reply. I tried and i am not getting desired behavior. Did you use anything for measures. Did you add Type as measure or anything specific?

I am always getting Last mentioned color. I believe i am doing something wrong in measures so that my expression is not recognizing.

Re: qlik sense stacked bar chart color expression

Anonymous — Thu, 22 Jan 2015 05:58:16 GMT

PFA

Re: qlik sense stacked bar chart color expression

Thu, 22 Jan 2015 06:20:39 GMT

Thanks. I did mistake when forming stacked chart. Thanks for help giving qvf