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: 
paulyeo11
Master
Master

How to make LY Bar color from RED to Gray ?

Hi All

See my enclosed QS FILE

5 Replies
swuehl
MVP
MVP

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

paulyeo11
Master
Master
Author

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 !

paulyeo11
Master
Master
Author

Enclosed my QVF file

swuehl
MVP
MVP

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

paulyeo11
Master
Master
Author

Hi Stefan

Many thank for your sharing , it is okay , I will try to live with it.

Paul

Sent from my iPhone