Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

not able to get 'By dimension' option in Colors and legend for bar chart

Hi,

i want to apply different colors to bars in bar chart,for this i have set auto color off,but i am only getting 3 options in dropdown not getting by dimension option.

here i have one dimension : client name

5 Expression ,each bar for each expression

Capture1.PNG

Please help me on this

Tags (1)
4 Replies
sureshqv
Esteemed Contributor III

Re: not able to get 'By dimension' option in Colors and legend for bar chart

select by exp and try to write exp lik below

if(sum([Gross Total])>50000 ,red() , if(sum([Gross Total]<10000 ),Green(), Yellow()))

Re: not able to get 'By dimension' option in Colors and legend for bar chart

So are you trying to get a color for each of your bar? May be try sort by expression:

Pick(Match([client name], 'Client1', 'Client2', 'Client3'.....), Blue(), Green(), Black(),....)

berryandcherry6
Contributor II

Re: not able to get 'By dimension' option in Colors and legend for bar chart

HI,

here i have only one client Dimension(only client) with different expression(bars for different expression) for that client.

How could i use this?

sureshqv
Esteemed Contributor III

Re: not able to get 'By dimension' option in Colors and legend for bar chart

apply lik below.. As sunny proposed.

clr.PNGclr1.PNG

Community Browser