Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Valued Contributor II

How to change the LY Bar color from Red to Gray ?

Hi All

How to change the LY Bar color from Red to Gray ?

Paul

11 Replies
paulyeo11
Valued Contributor II

Re: How to change the LY Bar color from Red to Gray ?

my qvf

shraddha_g
Honored Contributor III

Re: How to change the LY Bar color from Red to Gray ?

I doubt it is possible with Combo chart..

You can try Extension Qlik Branch.

Else Use valuelist () with Bar Chart

paulyeo11
Valued Contributor II

Re: How to change the LY Bar color from Red to Gray ?

Hi Shra

Thank you very much for your sharing .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

vikraant
Contributor

Re: How to change the LY Bar color from Red to Gray ?

Hi Paul ,

I have tried using Sense UI Combo Chart(Qlik Branch) to change the color of LY to grey. Is this what you wanted?

Regards,

Vikraant

Employee
Employee

Re: How to change the LY Bar color from Red to Gray ?

Hi Paul,

In 3.2 you can add the expression to the library as a measure. Then you can assign a color to the measure that can be used after you turn on "Use library measure colors" in the properties.

gray bar.PNG

Regards,

Patrik.

paulyeo11
Valued Contributor II

Re: How to change the LY Bar color from Red to Gray ?

Hi Sir

I have test your QVF file , it can make the Bar color now correct.

But then  Table 1 is correct , because the target line is below last year sales.

Table 2 the target is above both LY and CY sales , which is wrong.

How to make Table 2 same as Table 1 ?

Paul

vikraant
Contributor

Re: How to change the LY Bar color from Red to Gray ?

Hi Paul ,

It seems that there was minor change in the expression for Table 2 .

Expression used in Table 2 was

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales)

Whereas expression used in Table 1 is

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year)-1)}, sales = {'*'}>} month))"}>}sales/1)

After changing the expression the values are matching

Hope this helps!

Sorry for the delayed response!

Regards,

Vikraant

paulyeo11
Valued Contributor II

Re: How to change the LY Bar color from Red to Gray ?

Hi Sir

Your solution is correct , can you pls share with me why you make that change and it work fine ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

vikraant
Contributor

Re: How to change the LY Bar color from Red to Gray ?

Hi Paul,

I compared both the charts and checked the expression for LY in both the cases. In the second chart, in the expression for LY , In the set expression , max month for current year was found out. Due to this, the values were not matching.

After changing the expression , the values matched.

Regards,

Vikraant