topic Dimension Font colour in QlikView

Dimension Font colour

narband2778 — Mon, 11 Nov 2013 11:29:40 GMT

Hi guys,

I have a problem can anyone help me in this please.

In the selection pane i have filed "Number" contains values 1 to 10.

I have a bar chart with the same dimension as "Number".

Now if i select a single value from the "Number" filed then in my Bar chart I want to see that particular dimension value(font) in different colour and remaining dimension values should be white or hidden.

Thanks In Advance,

Naresh

Re: Dimension Font colour

jonathandienst — Mon, 11 Nov 2013 11:42:11 GMT

I assume that you have the bar chart working. If it reduces to a single bar when you select something in Number, then you will need to modify the expression to ignore the selection, using the set expression {<Number=>}, like

sum({<Number=>} value)

Then use the expression background color option (click the + next to the expression to get the option):

Enter an expression like (to highlight the selection in light red):

=if(WildMatch(GetFieldSelections(Number), Number), LightRed())

HTH

Jonathan

Re: Dimension Font colour

narband2778 — Mon, 11 Nov 2013 11:49:21 GMT

Thanks for your response Jonathan,

To ignore the selection worked well,

The logic which you gave me it is changing the colour of my bar, but i want to change the colour of dimension font to red.

Thanks,

Naresh

Re: Dimension Font colour

jonathandienst — Mon, 11 Nov 2013 12:19:12 GMT

Haven't tried this myself, but I suggest that you click the + sign next to the dimension (on the dimensions tab), and apply the expression to the Text Color option.

Jonathan

Re: Dimension Font colour

narband2778 — Mon, 11 Nov 2013 12:28:12 GMT

Thank you Jonathan

Re: Dimension Font colour

narband2778 — Mon, 11 Nov 2013 12:31:29 GMT

no i didnt worked for me.

Let me know if you have any other solution.

thanks in advance.

Naresh

Re: Dimension Font colour

Anonymous — Mon, 11 Nov 2013 12:46:30 GMT

Naresh

Could you post a sample qvw so we can see what the actual issue is.

Best Regards, Bill

Re: Dimension Font colour

narband2778 — Mon, 11 Nov 2013 14:37:57 GMT

Hi Bill,

can you please click the below link. I posted my application

http://community.qlik.com/thread/98588

thanks,

naresh

Re: Dimension Font colour

cgdonders — Sat, 15 Mar 2014 15:28:10 GMT

Hi naresh,

Do you already have a solution?

I think you can set the dimension font properties for each axes on the axes tab. Here you can apply the expression for the font color.

Re: Re: Dimension Font colour

SunilChauhan — Sat, 15 Mar 2014 15:43:48 GMT

see the attached file app and Image

hope this helps