Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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())