topic Re: X Axis Dates in QlikView

X Axis Dates

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please can someone help with the below.

I have a line graph where the x-axis is a date (dd/mm/yyyy hh:mm:ss) and the y-axis is volume. The date range is from 01/01/2020 - 21/04/2020.

I need the data to be a cumulative total, so I have selected full accumulation on the expression tab.

I would also like to only show data in the range 13/04/2020 - 21/04/2020 on the final visual.

I'm attaching a screenshot.

Any help is much appreciated.

Regards,
Daniel

Re: X Axis Dates

lironbaram — Thu, 30 Apr 2020 12:03:37 GMT

well if you want to limit it to last 8 days or so,

your expression should look like this

sum({<timestampField= {">=$(=timestamp(max(timestampField)-8))"}>}volume)

Re: X Axis Dates

danielnevitt — Thu, 30 Apr 2020 12:48:33 GMT

Hi,

Thanks for the reply. I need the data to be a full accumulation of all of the available data, however I just want to show the 8 days on the final graph. Is that possible?

Regards,
Daniel

Re: X Axis Dates

danielnevitt — Fri, 01 May 2020 10:57:22 GMT

Hi,

Did my message make sense?

If you are able to help, that would be much appreciated.

Regards,
Daniel

Re: X Axis Dates

Anil_Babu_Samineni — Tue, 05 May 2020 14:17:08 GMT

Perhaps this?

RangeSum(Above(TOTAL sum({<timestampField= {">=$(=timestamp(max(timestampField)-8))"}>}volume), 0, RowNo(TOTAL)))