topic Re: Chart help in Visualization and Usability

Chart help

camila1 — Thu, 07 Apr 2022 18:38:43 GMT

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!

Re: Chart help

Andrei_Cusnir — Fri, 08 Apr 2022 09:11:56 GMT

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:

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.
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/visualizations.htm

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

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

[4] https://help.qlik.com/en-US/sense-developer/February2022/Subsystems/Extensions/Content/Sense_Extensions/extensions-introduction.htm

[5] https://help.qlik.com/en-US/sense-developer/February2022/Subsystems/Extensions/Content/Sense_Extensions/extensions-getting-started.htm

Re: Chart help

eddie_wagt — Fri, 08 Apr 2022 09:42:37 GMT

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

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

Re: Chart help

camila1 — Fri, 08 Apr 2022 12:53:51 GMT

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!!!! 😀

Re: Chart help

eddie_wagt — Fri, 08 Apr 2022 13:14:10 GMT

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

Re: Chart help

camila1 — Fri, 08 Apr 2022 13:51:32 GMT

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

Re: Chart help

MarcoWedel — Sun, 10 Apr 2022 17:04:29 GMT

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)