Selecting Date Range on Line Chart

bskemp01 — Wed, 19 Mar 2025 22:11:20 GMT

I have a line chart that looks like this:

as you can see on Feb-6th the REV YTD has a value of $37,240,518.54. When i select a date range that includes this, see what happens below:

as you can see the value for Feb-6th is now $18,368,908.11. I need a way to select date ranges like this where my accumulation stays constant and shows the first value. is this possible in qlik?

here is my expression for REV YTD:

{$< Year={'$(=max([Year]))'}, [DateType]={'Invoiced'} >} RangeSum( Above( Sum([Company 1 Sales]) + Sum((1/[Rate])*[Company 2 Sales CAD]) + Sum([Company 3 Sales]) + Sum((1/[Rate])*[Company 4 Sales CAD]) ,0,RowNo(total) ) )

Re: Selecting Date Range on Line Chart

Digvijay_Singh — Wed, 28 Feb 2024 04:05:21 GMT

Probably you need to implement as of table instead of above function, check if that link helps -

https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130

topic Selecting Date Range on Line Chart in Data Movement & Streaming

Selecting Date Range on Line Chart

Re: Selecting Date Range on Line Chart