Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
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
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
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
Thank you Jonathan
no i didnt worked for me.
Let me know if you have any other solution.
thanks in advance.
Naresh
Naresh
Could you post a sample qvw so we can see what the actual issue is.
Best Regards, Bill
Hi Bill,
can you please click the below link. I posted my application
http://community.qlik.com/thread/98588
thanks,
naresh
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.
see the attached file app and Image
hope this helps