Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I set the color for the values in say a field called Product Group, e.g.Choclate = color Brown, Snacks = color Blue AND
set the color for each Product, in thier respective Product Group, e.g. Aero = color Red, , Crisps = color Green etc.
hiich
see the attached image
I set the color for the values in say a field called Product Group, e.g.Choclate = color Brown, Snacks = color Blue AND
set the color for each Product, in thier respective Product Group, e.g. Aero = color Red, , Crisps = color Green etc.
acc. to this
you put expression i.e
if(Product Group='Choclate',color(Brown()),
if(Product Group='Brown',color(Blue()),
if(Product Group='Aero',color(red()),
if(Product Group='Crisps',color(green())))))
hope it helps..
Hi,
Thanks for the response.
Your code will for Chocolat will work fine, if(Product Group='Choclate',color(Brown()), but
e.g. Aero, Snickers etc are Products in a seperate field e.g called Products and each product needs a seperate
color.
Your code results in the Products having the color Brown, Aero inherits Brown instead of showing Red.
What I need to see is
Choclat (Product Group field) = Brown
Aero (Products field) = Red
I'll also be using drill down in the Stacked Bar Chart.
Thanks
Hi,
Thanks for the response.
Your code will for Chocolat will work fine, if(Product Group='Choclate',color(Brown()), but
e.g. Aero, Snickers etc are Products in a seperate field e.g called Products and each product needs a seperate
color.
Your code results in the Products having the color Brown, Aero inherits Brown instead of showing Red.
What I need to see is
Choclat (Product Group field) = Brown
Aero (Products field) = Red
I'll also be using drill down in the Stacked Bar Chart.
Thanks
i m confused in it now you say clearly that product is separate field
so for in above code for aero try this
if(Product ='Aero',color(red()),
if(Product ='Crisps',color(green()))
hope it helps
Sorry for the confusion.
All values in the Product field inherit the Color Brown from if(Product Group='Choclate',color(Brown())
Using if(Product ='Aero',color(red()) is ibeing ignored,
Thanks
try this code.
alt(if(Product Group='Choclate',color(Brown()),
if(Product Group='Brown',color(Blue()),
if(Product ='Aero',color(red()),
if(Product ='Crisps',color(green()))))))
hope it helps
Hi QlikQuest,
I am assuming I understand what you want to achieve!
What you can do is click on the chart > Properties > Expression > click the + sign beside dimension > click Background color > then to the right side click the ecllipse (...) and paste this expression into the EDIT EXPRESSION window
if(Product Group='Choclate',color(Brown()),
if(Product Group='Brown',color(Blue()),
if(Product Group='Aero',color(red()),
if(Product Group='Crisps',color(green())))))
Click OK & OK
Regards,
Gabriel
Er,
I;m afraid that still doesn't work
All products, i.e. Aero are inheriting the Color Brown set by, if(Product Group='Choclate',color(Brown())
Thanks for sticking with it
Gabriel,
Thanks for your suggestion.
However what I need to see is
Choclat (Product Group field) = Brown
Aero (Products field) = Red
Mars Bar (Products field) = Orange etc
Your code results in All products Aeroet in the Products field being colored Brown.