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.JPG image3.JPG](https://community.qlik.com/t5/image/serverpage/image-id/39641iE58E3C9E5F2179DD/image-size/large?v=v2&px=999)
![image2.JPG image2.JPG](https://community.qlik.com/t5/image/serverpage/image-id/39642i00B1FF91BC2D68F2/image-size/large?v=v2&px=999)
![imagen1.JPG imagen1.JPG](https://community.qlik.com/t5/image/serverpage/image-id/39643i2B9CA0D8E57D5E54/image-size/large?v=v2&px=999)