Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

X Axis Dates

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 

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies
lironbaram
Partner
Partner

hi

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)

danielnevitt
Creator
Creator
Author

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

danielnevitt
Creator
Creator
Author

Hi,

Did my message make sense?

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

Regards,
Daniel

Anil_Babu_Samineni

Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post