Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

How to make LY Bar color from RED to Gray ?

Hi All

See my enclosed QS FILE

5 Replies
MVP
MVP

Re: How to make LY Bar color from RED to Gray ?

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
Valued Contributor II

Re: How to make LY Bar color from RED to Gray ?

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
Valued Contributor II

Re: How to make LY Bar color from RED to Gray ?

Enclosed my QVF file

MVP
MVP

Re: How to make LY Bar color from RED to Gray ?

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
Valued Contributor II

Re: How to make LY Bar color from RED to Gray ?

Hi Stefan

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

Paul

Sent from my iPhone