Negative Values In Set Analysis

Mon, 18 Apr 2011 17:50:52 GMT

Is there a way that negative numbers need to be expressed in Set Analysis? I have the following statement that works without issue. Date Diff is a field that determines how many weeks there are between the current week and the week that either (A) actual hours were logged or, (B) week that the hours are forecast to be logged. So, the number will positive for Actual Hours, and negative for Forecast Hours.

This works fine in figuring actual hours for the last four weeks (including the current week):

SUM( {$<[Week Ending Dt]=, [Date Diff] = {0,7,14,21} >} [Act Hours] )

This statement fails as soon as I put in the negative number indicator for four weeks in the future ('error in set modifier ad hoc element list'):

SUM( {$<[Week Ending Dt]=, [Date Diff] = {-7,-14,-21,-28} >} [Fore Hours] )

I know there are other ways of attacking it, but is there any way to get this to work?

Negative Values In Set Analysis

vgutkovsky — Mon, 18 Apr 2011 18:24:29 GMT

Jeff,

Try enclosing each number with single quotes.

Regards,

Negative Values In Set Analysis

Mon, 18 Apr 2011 18:38:19 GMT

That did it - thanks as always Vlad!

topic Negative Values In Set Analysis in QlikView

Negative Values In Set Analysis

Negative Values In Set Analysis

Negative Values In Set Analysis