Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
)
)
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
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