Year to Date for Fiscal Year using Range Sum function

Thu, 11 Dec 2014 03:38:40 GMT

Hi All,

I try to use RangeSum for YTD calculations. As you can see in the photo attached it work well when I select the maximum date (in this case September 2014), however if you choose October (there is no data for October yet) it still shows September figure which is distorting the data.

What I want to achieve is make any date beyond September 2014 unselectable as the data is not yet available.

Here is the set expression that I used.

=rangesum( above( sum({$<[Exec P&L Heading]={'NET PROFIT/ (LOSS)'},fYear = {"$(=Max(fYear))"},fMonth=,Quarter=, Year =, FMonth =, FYear =, Date, Year=,Quarter=, YearMonth = {"<=$(=max(YearMonth))"},Month= >} Amount*-1),0,12))

Is there any way to change 0,12 set values to 0, Max(Date)?

Many thanks in advance,

Chris

Re: Year to Date for Fiscal Year using Range Sum function

ecolomer — Thu, 11 Dec 2014 05:22:11 GMT

see this:

Fiscal Year

topic Re: Year to Date for Fiscal Year using Range Sum function in QlikView

Year to Date for Fiscal Year using Range Sum function

Re: Year to Date for Fiscal Year using Range Sum function