topic Re: YTD RangeSum - Need help with Set Analysis in QlikView

YTD RangeSum - Need help with Set Analysis

bmicqlik — Fri, 29 Jun 2012 00:47:14 GMT

I am trying to create a cumulative YTD total by month and this code works great and producing the right numbers:

RangeSum ((Above(Total [vEarned])), sum(if (InYeartoDate ( [Full_Date], vMonthEnd, 0) ), [earned], 0)),0)

I really do not want the previous months' to show up here and I think I need set analysis but cannot figure out the syntax.

Can anyone help ? I want the set analysis to work like the Inyeartodate function ........

Thanks in advance !!

jonathandienst — Fri, 29 Jun 2012 06:35:35 GMT

Assuming the MonthName column is a dimension, could you not just suppress zeroes in your table?

Regards

Jonathan

bmicqlik — Fri, 29 Jun 2012 10:33:29 GMT

It is and zeroes are suppressed yet it still shows this way.

Sent from my iPhone

jonathandienst — Sat, 30 Jun 2012 11:02:26 GMT

What other columns (expressiosn) in your table.

Might be easier to check if you post your model or a sample illustrating the problem.

Regards

Jonathan

bmicqlik — Tue, 03 Jul 2012 22:33:03 GMT

This expression works, except it repeats the

This year:

rangesum((Above([VEarned_TY])),sum({$<Year={$(=Max(Year))

Last year:

rangesum((Above([vIncurred_LY])),sum({$<Year={$(=Max(Year)-1)

BUT my dimension is month and the last month of this year repeats the last value when there is no value to display.....