Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us on May 23rd, Q&A with Qlik - Developer Series, Customizing Extensions: Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
uchandru85
Contributor
Contributor

How to plot every value of a measure?

How can I get a similar chart with every value as a dot for a given date?

diagram3_each_pollutant_index_point.png

My data has multiple value for each date and I can only get a line chart with aggregation on the measure. I want to plot every single value for each date.

Measurements captured multiple time on a day throughout the year.

Data.jpg

5 Replies
Ivan_Bozov
Luminary
Luminary

Try creating a scatter plot or just display the values in a pivot table.

vizmind.eu
swuehl
MVP
MVP

Maybe create a timestamp from your date and time and use this as dimension.

uchandru85
Contributor
Contributor
Author

If I use a scatterplot what would be the measures and dimension?

Ivan_Bozov
Luminary
Luminary

Try this:

X-axis: Only([Date Local])

Y-axis: Only(Time)

Dimension: [Sample Measurement]

vizmind.eu
uchandru85
Contributor
Contributor
Author

Thanks for the suggestion. It worked. Basically the dimension used should be a unique value in my case Timestamp.

Now I my chart looks like this due to the density of the dots. How can I make it look like the picture in my initial question. Also how can I adjust the grid lines to be month wise.

Plot.png