topic Re: Constant Background colour in App Development

Constant Background colour

zyn — Mon, 14 Jul 2025 15:40:49 GMT

Hi,

I had a requirement where i needed to make my chart static which i did by adding <DIM1,DIM2>,

but when selecting any dimension values it gives background for that particular dimension, i dont want my background color to change please suggest some way, below is my background expression:

=If((

(Sum({<DITDATE = {'$(=date(max(DITDATE)))'},Table_Flag = {'JAT'}>}TMP_Count) ) <= sum({<DITDATE>}Threshold_Green))

and (WildMatch(Measure,'BAKL','JAML','FATM'')), LightGreen(),

If(Sum({<DITDATE = {'$(=date(max(DITDATE)))'},Table_Flag = {'JAT'}>}TMP_Count) >= sum({<DITDATE>}Threshold_Red)

and (WildMatch(Measure,'BAKL','JAML','FATM'')),'#ec6969', //LightRed(),

If((Sum({<DITDATE = {'$(=date(max(DITDATE)))'},Table_Flag = {'JAT'}>}TMP_Count) > sum({<DITDATE>}Threshold_Green)) and (Sum({<DITDATE = {'$(=date(max(DITDATE)))'},Table_Flag = {'JAT'}>}TMP_Count) < sum({<DITDATE>}Threshold_Red) )

and (WildMatch(Measure,'BAKL','JAML','FATM'')), '#ffbf00','#d4e0ec'

)))

Re: Constant Background colour

Sayed_Mannan — Thu, 24 Jul 2025 09:33:19 GMT

Your current expression uses set analysis which is selection sensitive. you need to use set analysis that ignores selections by adding 1 to the set modifier.

for e.g- instead of Sum({<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count

you can use
Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count

based on this, here is your revised background color expression:

=If(
    (Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count) <=
     Sum({1<DITDATE>} Threshold_Green)) and
    WildMatch(Measure, 'BAKL', 'JAML', 'FATM'),
    LightGreen(),
    If(
        Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count) >=
        Sum({1<DITDATE>} Threshold_Red) and
        WildMatch(Measure, 'BAKL', 'JAML', 'FATM'),
        '#ec6969',
        If(
            Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count) >
            Sum({1<DITDATE>} Threshold_Green) and
            Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count) <
            Sum({1<DITDATE>} Threshold_Red) and
            WildMatch(Measure, 'BAKL', 'JAML', 'FATM'),
            '#ffbf00',
            '#d4e0ec'
        )
    )
)

I hope this helps.

Re: Constant Background colour

zyn — Mon, 28 Jul 2025 11:44:18 GMT

@Sayed_Mannan i tried using above expression but it is not working.