Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

RGB Color inside the Title expression

Hi Experts,

I would like to fix a RGB Color  "1429a0" for the Brand Mazada.  If Brand is Mazada then RGB "1429a0 " else other colour.

I am writing this expression in Title under Bell Chart, Hence not possible to use a Master Dimension colour. 

Purushothaman_0-1655949188964.png

 

Any Work arounds. Please help. 

Below is the expression:

= 'MAZADA'&
DUAL(

NUM(SUM({<BRAND={'MAZADA'},BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV)
/
SUM(TOTAL<PRICESEG, COUNTRY,[Year Month Base],[Year Quarter Base],[Year Half Base]>{<BRAND,BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV),'#,##0.0%')

& '(' &

NUM(SUM({<BRAND={'MAZADA'},PRICESEG,BrGrp1,BrGrp2, [Year Base],[Year Half Base],[Year Quarter Base],[Year Half Base (YYYYHH)] ,[Year Month Base], [Year Quarter Base (YYYYQQ)], Year_Offset={"0"},[Year Month_Offset]={"0"}, [Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV/$(pSwt_Unit))

/
SUM({<BRAND={'MAZADA'},PRICESEG,BrGrp1,BrGrp2, [Year Base],[Year Half Base],[Year Quarter Base],[Year Half Base (YYYYHH)], [Year Month Base], [Year Quarter Base (YYYYQQ)], Year_Offset={"0"},[Year Month_Offset]={"0"}, [Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}RR/$(pSwt_Unit)),'#,##0')
&')' ,

 

NUM(SUM({<BRAND={'MAZADA'},BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV)
/
SUM(TOTAL<PRICESEG, COUNTRY,[Year Month Base],[Year Quarter Base],[Year Half Base]>{<BRAND,BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV),'#,##0.0%')
)

0 Replies