Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing issue when am using Monochrome color ( Warm Grey) for Geo Map while try to show heat map from Lighter Grey to Dark according to minimum to maximum count of Order number
I have used the below formula in Geo map( it is in BOLD letters) but I am not getting expected shading like heat map ( Lighter to Darken )
PFA screen shot..
=''// DYNAMIC MAP SETTINGS
/*
Important: When you use different dimensions for polygons and markers you have to use the Aggr(NODISTINCT ...) function for all aggregation functions like: Sum(), Max(), Min(),...
to make sure QlikView sums up the values for the polygon dimension - Sample: Aggr(NODISTINCT Sum(Field),PolygonDimension)
*/
//& '#Coordinates=' & aggr(REPLACE_THIS_BY_YOUR_COORDINATES , REPLACE_THIS_BY_YOUR_POLYGON_DIMENSION)
& '#Color=' & ColorMix1(RowNo(TOTAL)/NoOfRows(TOTAL),RGB(220,220,220),RGB(47,79,79))
//=ColorMix1(Count({<Table={'ORFT_comment_tbl'}>}Order_Number)/Count({<Table={'ORFT_comment_tbl'}>}Total Order_Number),RGB(220,220,220),RGB(47,79,79))
//& '#Color%=' & Count({<Table={'ORFT_comment_tbl'}>}Order_Number) //Count ([Order Number])
//& '#Color=' & if(Count({<Table={'ORFT_comment_tbl'}>}Order_Number)< 10,'Green',
//
// if(Count({<Table={'ORFT_comment_tbl'}>}Order_Number)< 15, 'Yellow',
// if(Count({<Table={'ORFT_comment_tbl'}>}Order_Number)< 20, 'orange',
// if(Count({<Table={'ORFT_comment_tbl'}>}Order_Number)< 30, 'lightyellow',
// if(Count({<Table={'ORFT_comment_tbl'}>}Order_Number)< 50, 'lightblue',
// if(Count({<Table={'ORFT_comment_tbl'}>}Order_Number)< 90,'Darkgrey', 'lightgreen'))))))
//& '#Color=' & if(sum(Sales)<100000, 'red',
// if(sum(Sales)<200000, 'orange',
// if(sum(Sales)<300000, 'yellow', 'green')))
//& '#KPI=' & 0
//& '#AnimID=' & 0
& '#BorderColor=' & 'gray'
//& '#Opacity=' & 50
//& '#BorderSize=' & 0.5
//& '#Popup=' & ''
& '#MouseOver=' & [MAN_Contry Code] & Count({<Table={'ORFT_comment_tbl'}>}Order_Number)
//& '#Label=' & ''
//& '#Note=' & ''
//& '#NotePosition=' & '' // tl, tr, bl, br, cl, cr, ct, cb, cc
//& '#PolygonImageURL=' & ''
//& '#ImageChart='
//& '##Type:' & 1
//& '##Data:' & '400|900'
//& '##Label:' & 'A|B'
//& '##Color:' & 'red|yellow'
//& '#PopupChart='
//& '##Type:' & 4
//& '##QVChart:' & ''
//& '##Data:' & '400|900'
//& '##Label:' & 'A|B'
//& '##Color:' & 'red|yellow'
//& '##Title:' & ''
//& '##Width:' & 350
//& '##Height:' & 200
//DESCRIPTION********************************************************************************************
//POLYGON SETTINGS
//& '#Coordinates=' & '' // MAP/Polygon Coordinates using Encoded Polylines format
//& '#Color=' & 'orange' // Fill color. RGB(0,0,0), HEX Codes like: #FFFFFF or windows standard colors like: 'white', 'blue',... can be used.
// When no specific color is set the system uses the color set defined in the expert settings Polygon.colors
//& '#Color%=' & 0 // Number value used to calculate the color based on a Class definied in Class Settings on Basic Tab
//& '#AnimID=' & 0 // Animation ID used to sort and group animated Objects
//& '#KPI=' & 0 // Key Performance Indicator used to summarize groups of polygons. Ex.: Used in Radial Sphere definition
//& '#BorderColor=' & 'white' // Border color, no entry means no border. RGB(0,0,0), HEX Codes like: #FFFFFF or windows standard colors like: 'white', 'blue',... can be used.
//& '#Opacity=' & '50' // Opacity % for each Polygon 0-100
//& '#BorderSize=' & '0.5' // Border Size in Pixel
//& '#Popup=' & '' // Information to be shown on mouse-click on object
//& '#MouseOver=' & '' // Information to be shown on mouse-over on object
//& '#Label=' & '' // Label to be shown below each object
//& '#Note=' & '' // HTML based content shown below each object (versatile but slower then Labels)
//& '#NotePosition=' & '' // Relative Position to Marker: tl=Top Left, tr = Top Right, bl = Bottom Left, br = Bottom Right, cl = Center Left, cr = Center Right, ct = Center Top, cb = Center Bottom, cc = Center Center
// Image Path: /QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/NPGeoMap_v2_3/images\
//& '#PolygonImageURL=' // Path to local image inside the image folder or URL to an png Image
//CHART SETTINGS
//& 'Type:' & 1 // 0=OFF, 1=PIE, 2=DOUGHNUT, 3=HORIZONTAL BAR, 4=VERTICAL BAR, 5=LINE, 6=CURVED LINE, 7=QLIKVIEW CHART
//& 'QVChart:' & '' // QlikView Object ID. You can use all QlikView Charts as Popup Chart
//& 'Data:' & '400|900' // Data for the charts, each value must be seperated by a pipe | sign
// In order to get data from QlikView, pipe seperated, you can use the Concat() function
// Sample: Concat(Aggr(sum(Sales),ID, Month),'|',Month)
// Sample: Concat(DISTINCT Month, '|', Month)
//& 'Color:'& 'red|yellow' // Colors for each data series.
// When no color is set the system uses the the colorset defined in the expert settings chart.colors
//& 'Label:' & 'A|B' // Label for each data series.
//& 'Title:' & '' // Title inside the chart
//& 'Width:' & 350 // chart popup container pixel width (Only valid for popup charts)
// Use image size for Image charts - defined in menu: marker image settings
//& 'Height:' & 200 // chart popup container pixel height (Only valid for popup charts)
// Use image size for Image charts - defined in menu: marker image settings
/*
Can you please suggest or guide me how can show heat map by using Grey color in Qlikview by using N-Geo Map