Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
See my enclosed QS FILE
Hi Paul,
have a look at
Use Case for ValueList Chart Function
Hence, you might need to work with a ValueList() dimension(s).
Hope this helps,
Stefan
Hi Stefan
Thank you for share with me the link.
I found the script most suitable for me is below :-
If(ValueList('Oscars', 'Nominations')='Oscars', '#e1aa3d', '#ccc')
So i try using below expression :-But i get all red color.
If(ValueList('CY', 'LY')='LY', 'BLUE', 'RED')
I also try below exrepssion , i get all gray color.
If(ValueList('CY', 'LY')='CY', '#e1aa3d', '#ccc')
Where i go wrong ?
Paul !
Enclosed my QVF file
Hi Paul,
You would need to create an additional dimension with ValueList() and transform your multiple expressions into one checking the ValueList() to branch into the specific expressions to make this solution work.
But I missed that you were using a combo chart, which does not allow multiple dimensions AFAIK. You also need multiple expressions for the bar and the symbol display.
So maybe the proposed solution won't work in your setting anyway.
Sense is currently more limited than QV with regard to custom coloring. Maybe you can search for extensions with better custom color capabilities.
Regards,
Stefan
Hi Stefan
Many thank for your sharing , it is okay , I will try to live with it.
Paul
Sent from my iPhone