Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
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:
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.
---
[2] https://developer.qlik.com/garden
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
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!!!! 😀
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
The Excel should be saved in someplace in particular? I don't know why I have this error.
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)