Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to utilize in built Map chart in the Dashboard but facing issue in it.
Attached is the pic of the same.
Middle chart coming fine with the Color combination required
i.e.
Low Range | High Range | ||||
rgb(192,000,000) | C00000 | Red | <-15 and Below | -15 | |
rgb(255,192,0) | FFC000 | Amber | >=-15 to <0 | -15 | 0 |
rgb(146,208,80) | 92d050 | Green | >=0 to <=15 | 0 | 15 |
rgb(84,130,53) | 548235 | Dark G | 15 and Above | 15 |
Formulas Used:
Map 1 | |||
vDSFLPvsBUDCERFY% | num(Alt((sum({$<DataFlag={'LP'},[MRH COA Level 9]={90001000},CalendarYear={$(vYearSelection)},CalendarMonthNumber={">=1<=12"},[LP Reporting Month]={$(vLPMaxMonth)},CalendarMonthName=>} [VAR LP BUD CER])/ | ||
sum({$<DataFlag={'Sales/GP'},Sales={"*"},CalendarMonthNumber={">=1<=12"},CalendarYear={$(vYearSelection)},[LP Reporting Month],CalendarMonthName=>}BUD)),0)*100,'#,##0.0') | |||
Map 2 | |||
vSalesYTDBudCER% | num(ALT((sum({$<DataFlag={'Sales/GP'},Sales={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>}[VAR ACT BUD CER])/ | ||
sum({$<DataFlag={'Sales/GP'},Sales={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>} BUD)),0.0)*100,'#,##0.0') | |||
Map3 | |||
(vGpCERYTD%) | if(not isnull(num((sum({$<DataFlag={'Sales/GP'},GP={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>}[VAR ACT BUD CER])/ | ||
sum({$<DataFlag={'Sales/GP'},GP={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>} BUD) )*100,'#,##0.0')), | |||
(num((sum({$<DataFlag={'Sales/GP'},GP={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>}[VAR ACT BUD CER])/ | |||
sum({$<DataFlag={'Sales/GP'},GP={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>} BUD) )*100,'#,##0.0')) ,0.0) |
Inside the Map:
Under Layers:
Dimension used: ISO Code
Location type: Country Code ISO 2
Color:
"Expression" is selected and wrote:
If($(vDSFLPvsBUDCERFY%)>=15,RGB(84,130,53) ,
if($(vDSFLPvsBUDCERFY%)>=0 and $(vDSFLPvsBUDCERFY%)<=15, rgb(146,208,80) ,
if($(vDSFLPvsBUDCERFY%)>=-15 and $(vDSFLPvsBUDCERFY%)<0, rgb(255,192,000),
if($(vDSFLPvsBUDCERFY%)<-15,rgb(192,000,000)
))))
The check - box of Expression is color coded is checked.
Map 1 and Map 3 are coming in Amber color where as Map 2 coming in all the given colors.
Kindly extend your help.
Thanks and Regards,
Pradnya.
Which version of qs you are using there
was issues in old version. Have you checked
The same in local desktop?
Regards
Vikas
We have April version 2018 an QlikServer 12.16.2