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: 
kevinmohu
Contributor
Contributor

Heat map-create a new field(of existent fields)

Hi guys,
I'm a new in QLIK SENSE, My table structure (image 1) contains 12 symptoms (fever, cough,headache,...) and all of them are text data type where '0'=doesn't have this symptom or '1'=have this symptom. I'd like to set a heatmap betwen date and these symptoms. The fact is a heatmap structure just allows me put 2 dimension and 1 measure. I have 12 fields of symptoms, i'll have to create a new field as an array or list called "sympthom" and envolve all these 12 symptoms in one field.(This is my idea but i cannot get it until now).

I tried to simulate it, so, i set fixed values (image 2,3), but i cannot do with real time data, because the editor doesn't allow to use functions or conditionals.

Could you give any ideas please?

Thanks in advance.

image3.JPGimage2.JPGimagen1.JPG

Labels (1)
0 Replies