Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a bar chart where I want to show salary by Title and Office.
Currently chart looks like this:
How can I show the office labels under the bar?
I recally QlikView being able to do that in the past but not sure how.
Any suggestions please?
Add a third dimension, may be just a static 1 and see what it does? Or share your sample qvw to test it out
Try below.
1.Add another dimension
2.Hide the label and legend of the new dimension
3. Add below script into the back ground color expression.
=if(Office=1,color(1),
if(Office=2,color(2),
if(Office=3,color(3),
if(Office=4,color(4),
if(Office=5,color(5))))))
Please find the attachment for more detail.
Something like this?
workaround for this is adding a psuedo dimension,but you cannot use more than one expression if you are using 3 dimensions here.check out the qvw attached