topic Re: Chart - show value for every 15 min in QlikView

Chart - show value for every 15 min

Tue, 14 Apr 2015 08:51:02 GMT

Hi,

I have a few thousand data points every day and I would like to illustrate it in a chart.

However, showing all of the dimension data points does not work pls see below:

I need to show fewer values across the day. Maybe one every 15 minutes.

I was thinking somehow maybe pick the last value for every 15 minutes.

Any ideas?

Pls find attached example file.

Regards

//Olle

Re: Chart - show value for every 15 min

Anonymous — Tue, 14 Apr 2015 10:06:00 GMT

The attached shows average balance over 15 minute time buckets.

Re: Chart - show value for every 15 min

rubenmarin — Tue, 14 Apr 2015 10:32:40 GMT

Hi Olle, this attachment shows, each 15 minutes, the value of the last value in that period.

If you load TIME as a time (number) you can avoid the Time#() in graphs.

Re: Chart - show value for every 15 min

Anonymous — Tue, 14 Apr 2015 14:11:31 GMT

I would personally put into the load script the code to create a new field for the 15 minute buckets which can then be used as your dimension.

Calculated dimensions should always be avoided where possible, but I often use them in cases like this to first test a theory before putting it in the script.