Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Not applicable

new

new

1 Solution

Accepted Solutions
eliran_s
Contributor II

Re: Heat map in qlik sense

Hi Monica,

Please check 'Consumer good sales' model in the samples provided by Qlik, under 'Sales & Margin Analysis' sheet.

You will be able to achieve something similar to what you wanted, but the colors will look a bit different out of the box.

You achieve this by going to : Appearance - Colors and legend - tick the auto from color, set it 'By measure', write the expression of your choice (Measure) and choose your desired color schema.

temp.png

Another approach if you want to use the colors of your choice, is coloring with the help of colormix1 function.

For example: ColorMix1(Sum ([Sales Amount])/Sum (total [Sales Amount]),white(),rgb(8,70,147))

Where the first value of colormix is a number ranged from 0-1 (In my example, the sales % of each state), and the other variables are the colors you want (in my case, I took your desired dark blue, and white).

TENO.png

Please mark the appropriate replies as CORRECT / HELPFUL so other members know that your question has been answered to your satisfaction.


Hope it helps,

Eliran.

3 Replies
eliran_s
Contributor II

Re: Heat map in qlik sense

Hi Monica,

Please check 'Consumer good sales' model in the samples provided by Qlik, under 'Sales & Margin Analysis' sheet.

You will be able to achieve something similar to what you wanted, but the colors will look a bit different out of the box.

You achieve this by going to : Appearance - Colors and legend - tick the auto from color, set it 'By measure', write the expression of your choice (Measure) and choose your desired color schema.

temp.png

Another approach if you want to use the colors of your choice, is coloring with the help of colormix1 function.

For example: ColorMix1(Sum ([Sales Amount])/Sum (total [Sales Amount]),white(),rgb(8,70,147))

Where the first value of colormix is a number ranged from 0-1 (In my example, the sales % of each state), and the other variables are the colors you want (in my case, I took your desired dark blue, and white).

TENO.png

Please mark the appropriate replies as CORRECT / HELPFUL so other members know that your question has been answered to your satisfaction.


Hope it helps,

Eliran.

qlik_aparna
New Contributor III

Re: Heat map in qlik sense

Hi Monica,

You can use Show/Hide container extension available in Qlik Branch  to drill down your maps.

Regards,

Aparna

Not applicable

Re: Heat map in qlik sense

Hi Eliran, can you please provide a link to the sample file, I am having difficulties configuring the colors. Thank you. -Monica

Community Browser