color coding expression in table chart

[yogitamehta10]

Hi All,

i have one issue , i have one table chart in qliksense , have 9 dimensions and one measure , i'm trying to use color coding in measure , just wanted to change the color of measure as per dimensions value .

As i have a dimension Status , so if status is accepted value should be blue otherwise red . expression is working  in color expression , but due to this expression my data is geeting effective

my actual measure expression is

sum({<[ID]={'2A','2B'},[Status] ={'Accepted','Rejected'},[[YEAR]={$(=max([YEAR]))},

[Calender MONTH]={$(=max([Calender MONTH]))}>}[Charge])

color coding expression is

if (status= 'Accepted', red(), blue())

how should i write my color coding expression that it should not effect my actual expression ,

what is happening now my table started showing all the ID , it is not considering the filter   2A and 2B as defined in set analysis.

m i doing something wrong.

[swuehl]

Try to apply the set expression also to the color expression:

if (

Only({<[ID]={'2A','2B'},[Status] ={'Accepted','Rejected'},[[YEAR]={$(=max([YEAR]))},

[Calender MONTH]={$(=max([Calender MONTH]))}>} status)

= 'Accepted',

red(), blue())