heat map chart

[#1]

Hi Experts,

i have the following data

Hour	Quantity
0	9
1	3
2	2
3	4
4	3
5	7
6	3
7	4
8	4
9	3
10	2
11	5
12	4
13	2
14	4
15	5
16	5
17	3
18	3
19	5
20	6
21	7
22	4
23	3

i need to do heat map chart for this data.

Can anyone please help me how to do this? i have never done this

[kaushiknsolanki]

Hi, Have a look at the attached application.

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

i m expecting different colours not single colour.

my expression is count(distinct quantity)

Please help me with my expression

[kaushiknsolanki]

Hi,

Its a different shade of the color.

Also with the sample data it will show you 1 as count for all hours.

Kindly give some more meaningful sample data.

Regards,

Kaushik Solanki

[trdandamudi · Accepted solution]

Please follow below link and you will be able to find a solution:

Qlikview Heatmaps

Hope this helps....

[#6]

with this data?

WeekDay	Volume
Mon	17
Tue	17
Wed	12
Thu	15
Fri	13
Sat	14
Sun	12

[#7]

thank you so much

[trdandamudi]

No problem.... Glad to know that it worked for you...