How to change the bg and font color of dimension

[jagannalla]

Hi,

How i change the background and font color of dimension in straight table. And also how can i change the background and font color of header text in the table.

Thanks,

Boppy

[Oleg_Troyansky]

I just shared a QlikView called "Colors", that shows exactly how to do it via macro. Wait for it to be approved by the moderator, and download when it becomes available.

Have fun!

Oleg

[Oleg_Troyansky]

Here is the link to the document:

http://community.qlik.com/qlikviews/1137

[#4]

Hi Oleg, thanks a lot a lot for the file, you are the boss. Let me try it and I will tell you cos I ahve to adapt the code to my file.

Thanks again.

[#5]

Hi Oleg, with that code is possible to modify the background color of one specific cell in the table?

Thanks again mate.

[Oleg_Troyansky]

For one specific cell, I'd rather recommend using Expression (or Dimension) attribute for Background color, and apply a condition. For example, something like this:

IF(Sum(Sales)>1000000, blue(), white())

[#7]

But I would need to do it with a macro cos it is to highlight the discrepancies between two fields in different tables that are nor related each other, so my idea is to show both fields in different straight tables and with a macro compare each value with the other straight table and if that value doesnt appear there, is highlighted in red colour for example.

Thanks a lot for your help.

[Oleg_Troyansky]

I don't know how to change a single cell in a macro. Try applying the same logic that you were planning to apply in the macro, within a condition that you could apply within the chart attributes...

[#9]

Hi Oleg,

I want to use different colour in 1 dimention as shown in the Attachment. Is it possible to show like this or similar type? Please help me reharding this.

- Yojas

[#10]

Would it be possible to post that file again. Or to share the example macro code how to manipulate with the strait table properties?

I'm trying to change the vertical border colors in the straight table. (horizontal in the Pivot table) i.e. from black to red.

As you can see I'm in the design mode, so I already used the "Custom Format Cell". Also you can see that I was switching between strait and pivot tables ( these were other suggestions on the forum). It looks like there is not option to change that border's color.

[ZoeM]

Thats good info.

When I go to Custom Format Cell-->Apply change to drop down, I only have the All Dimensions option and not Current Dimension.

Am I missing something??