Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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