Chart help

[camila1]

Hi everyone! I want to do a graph like this one:

In green should appear the days without accidents

In yellow should appear the days with minor accidents

In red should appear the days with major accidents.

Someone knows how could I do this graph where I can see the days with the colors that I mentioned before, filter by month, and have the form of the picture?

Thanks!

[Andrei_Cusnir]

Hello,

This is a custom visualization that doesn't exists in Qlik Sense natively. For existing native visualizations you can check the official documentation "Visualizations" [1].

You can check the "Qlik Developer > Garden" [2], for custom visualizations/extensions developed by other developers, however I doubt that there is any design similar to the one that you have posted. 

You only have 2 options:

1. Submit a feature request [3], to have this visualization natively available and elaborate in detail as to why it will be beneficial for you and for other users.
2. Create your own "Visualization extensions" [4], by starting with following the guide such as "Getting started building visualization extensions" [5]

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 
 

---

[1] https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/visua...

[2] https://developer.qlik.com/garden

[3] https://community.qlik.com/t5/Knowledge-Base/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1...

[4] https://help.qlik.com/en-US/sense-developer/February2022/Subsystems/Extensions/Content/Sense_Extensi...

[5] https://help.qlik.com/en-US/sense-developer/February2022/Subsystems/Extensions/Content/Sense_Extensi...

[eddie_wagt]

Have a look here https://community.qlik.com/t5/Qlik-Sense-Documents/Top-10-Viz-tips-QlikWorld-2021-part-V/ta-p/178757...

Open the QVF and go to sheet Cartograms. With the help and Excel file as template you can apply this for your solution. 

@Patric_Nordstrom made this beauty

[camila1]

Great! Thanks for your help! I'm new at Qlik and I don't know how to use crosstable to convert to a straight table and to add coordinates and grid geometries in the load script. Could you help me with this too?

Thanks!!!! 😀

[eddie_wagt]

Hello,

If you check the loadscript of the QVF (section Cartogram) and the Excel file us_grid then you only have to change the Excel. 

Regards

Eddie

[camila1]

The Excel should be saved in someplace in particular? I don't know why I have this error.

[MarcoWedel · Accepted solution]

Just tried using a pivot table to create this visualization,

due to the grid lines it might not look quite as nice but nevertheless seems to work:

Using  this Row expression:

=Aggr(Pick(Day(Date),1,2,2,2,3,3,3,3,3,3,3,4,4,4,4,4,4,4,5,5,5,5,5,5,5,6,6,6,7,7,7),Date)

and this column expression:

=Aggr(Pick(Day(Date),4,3,4,5,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,3,4,5,3,4,5),Date)