topic Re: How to lock the color code ? in App Development

How to lock the color code ?

keliane — Tue, 03 Sep 2024 03:43:58 GMT

Hi,

I'm using a graph that's displaying [Net Income] for the year 2024, 2023 and 2022. I've put 3 variables (v2024, v2023, v2022) and when the this variable = 0, it doesn't display the net income for this year.

The thing is, when the user want to display only 1 year and displaying multiple years after, the color code is setting automatically to '1 color'.

Any Ideas ? Thanks !

Re: How to lock the color code ?

justISO — Tue, 03 Sep 2024 05:15:03 GMT

Hi, maybe you can try 'lock' color on years, not variables, with color expression like: if(year=2024, red(), if(year=2023, green(), yellow()))

Re: How to lock the color code ?

keliane — Tue, 03 Sep 2024 06:52:49 GMT

Hi,

This expression is not working for me 😕

This is my expression I'm Using for Year 2024 :

Sum({<[Committed Limit]-={'Yes'},[Report Date.autoCalendar.Year]={$(=Max(Year))}>} [Exposure])
/
Count(Distinct {<[Report Date.autoCalendar.Year]={$(=Max(Year))}>} [Report Date])

Thank you !

Re: How to lock the color code ?

keliane — Wed, 04 Sep 2024 08:38:19 GMT

Hi,

Still didn't find out guys //

Re: How to lock the color code ?

gomeri — Wed, 04 Sep 2024 09:12:28 GMT

Hi @keliane,

it is possibile that functions $(=Max(Year)) doesn't work?

Try this instead of your expression:

Sum({<[Committed Limit]-={'Yes'},[Report Date.autoCalendar.Year]={'$(=Max(Year))'}>} [Exposure]) / Count(Distinct {<[Report Date.autoCalendar.Year]={'$(=Max(Year))'}>} [Report Date])

Re: How to lock the color code ?

keliane — Thu, 05 Sep 2024 02:15:48 GMT

My expression is working well, the problem is just coming from the color expression. I'm using a line chart btw, with multiple variable. Here is my full expression (that is working perfectly for the LINES) :

If(
vShowCommited = 0,
//Show ONLY exposure for UNCommited Lines
Sum({<[Committed Limit]-={'Yes'},[Report Date.autoCalendar.Year]={'$(=Max(Year))'}>} [Exposure])
/
Count(Distinct {<[Report Date.autoCalendar.Year]={'$(=Max(Year))'}>} [Report Date])
,
If(
vShowUncommited = 0,
//Show ONLY exposure for UnCommited Lines
Sum({<[Committed Limit]-={'No'},[Report Date.autoCalendar.Year]={'$(=Max(Year))'}>} [Exposure])
/
Count(Distinct {<[Report Date.autoCalendar.Year]={'$(=Max(Year))'}>} [Report Date])
,
//Show Exposure for Commited+Uncommited
Sum({<[Report Date.autoCalendar.Year]={'$(=Max(Year))'}>} [Exposure])
/
Count(Distinct {<[Report Date.autoCalendar.Year]={'$(=Max(Year))'}>} [Report Date])))

It's working well with the option 'Mulicoloured' but when I'm displaying only 1 years (With buttons affiliated to variable) the option 'Multicoulored' change automatically to 'Sing Colour' and not coming back. So that's why I need a colour expression.

Thanks for the one who's willing to help me !

Re: How to lock the color code ?

keliane — Thu, 05 Sep 2024 03:28:49 GMT

I tried this expression :

If(
Column(1), // For Measure 1 (Current year)
RGB(255, 0, 0), // Red for Measure 1

If(
Column(2), // For Measure 2 (Previous year)
RGB(0, 255, 0), // Green for Measure 2

If(
Column(3), // For Measure 3 (Two years ago)
RGB(0, 0, 255) // Blue for Measure 3
)))

And it gave me something very strange, seems like the measures are being mix together ? I join you a screenshot !

Re: How to lock the color code ?

keliane — Fri, 06 Sep 2024 09:48:09 GMT

Update : Still didn't fid the answer

Re: How to lock the color code ?

keliane — Mon, 09 Sep 2024 05:34:57 GMT

Still pending argghhhh

Re: How to lock the color code ?

keliane — Mon, 09 Sep 2024 06:06:35 GMT

I found hahaha it's very easy finally.

Just add a master item to your measure ! You can find it under the expression of your measure.

Great day all.