Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Background color in dimension

Hi guys,

is it normal that it's not possible to have a background color with the dimension set along the X-axis?

In this example I set the LightRed() as the background color of the Anno dimension, but it's visible only if I Set the dimension in the first image and not if I set it as the second one.

Is there a workaround to avoid it?

Thank you so much.

N.

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

One option is you change color by custom format cell

For this go to User Preference -> Design  tab -> Check "Always Show Design Menu Items"

Once you do this and apply settings.

Right click on the dimension and check for the option "Custom Format Cell"

Here select the background you want and also change the font color.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

Hi,

thank you for the reply; i made what you've suggested

but on the right click on the dimesion I can't find the "Custom Format Cell" option (only the "Delete dimension" option is available on the righe click

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Not in the property window. It is on the chart (Visualization).

Untitled.png

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
surendraj
Specialist
Specialist

Here You can right click on the object(Straight table),This means Right click on the particular cell in object --->Custom Format cell-->Apply background color as you want.

the custom format cell enable only after you pick User Preference -> Design  tab -> Check "Always Show Design Menu Items"

Anonymous
Not applicable
Author

...it seems to be a good suggestion, but it doesn't work properly:

I choose the dimension (the day, not the year), select the "backgorund color" option, select "Calculated" to insert my formula:

=If(IdAttivitaPresenza<>Null(),If(Weekday(DataPresenza)=6,$(ColDomenica),If(Weekday(DataPresenza)=5,$(ColSabato),$(ColFeriale))))

click OK

But when I click OK to close the above windows, my formula has been lost

😞