Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QlikViewers,
I am faced with a peculiar problem that does not seem solvable our of the box in QlikView.
A piechart has one dimension and one measure. The dimension has say 4 values. Hence there are 4 different color pieces in the pie chart. Say $Sales for North, Souch, East and West regions. I want to color the east region in white(or any other color), and the remaining three pieces in the same color, say Red. Thus the piechart will have only 2 colors at most. Is this doable?
Thanks
Raghu
Goto Expression Tab then select the Expression + symbol in the Bckground colour
Add
If(Dimension='East',RGB(255,255,255),RGB(255,0,0))
Goto Expression Tab then select the Expression + symbol in the Bckground colour
Add
If(Dimension='East',RGB(255,255,255),RGB(255,0,0))
Hi Raghuvansh,
You may use the expression :
=if(Region ='east',White(),Red())
This will solve your problem.
Regards,
Snehal Nabar
Thanks a lot guys.
All of these answers are correct, but I see that I can only mark one answer as correct
Regards
Raghu