topic Qlikview Visualizations in QlikView

Qlikview Visualizations

spetushi — Sat, 16 Nov 2024 21:33:17 GMT

Hello QlikView Community,

I am looking at using a scatter plot in QlikView to visualize timeline of events. See attached sample data, sample qvw, and screenshot of what I have gotten so far. I would like to show Month-Year of Event in the X axis, and Event in the Y axis, with the Event name in the bubbles as well. I would like to only show sorted Month-Year of Events in the X axis and omit dates without events. There are events with 'N/A' as Event Date which I would like to display as well on the right side.

Thank you

Sokol

Re: Qlikview Visualizations

jyothish8807 — Wed, 23 Jan 2019 06:24:57 GMT

Hi Spetushi,

May be like this ?

Re: Qlikview Visualizations

spetushi — Wed, 23 Jan 2019 21:54:36 GMT

Thank you for taking a shot KC.

This helps, but will need to align the Y axis with the corresponding event bubble. I will look at it in more detail this evening.

Sokol

Re: Qlikview Visualizations

spetushi — Thu, 24 Jan 2019 02:17:12 GMT

I was able to account for the misalignment of the bubbles with the Y axis events by changing the sorting logic:It shows correctly for USHowever the labels are missing when I pick DE as the country

See attached new version. In the Sort settings, I used Expression to sort for the Event Date: =If([Event Date]='N/A',99999,[Event Date])

For the Event dimension, I removed the sort on Text and only using State. Not sure why some of the bubbles are missing the label.