topic Set analysis not working in QlikView

Set analysis not working

Thu, 08 Dec 2011 12:15:08 GMT

Hi,

can anyone tell me what I am doing wrong on the code below as it come up with a zero value when I know it should calculate a value

=sum({$<CalendarYear = {$(='2010')},Rebate_Reference = {$(='1')}>}[Sales_Value])

many thanks

Nick

swuehl — Thu, 08 Dec 2011 12:20:21 GMT

Hi,

is there a special reason why you use dollar sign expansion for a literal within the set elements?

Try this:

=sum({$<CalendarYear = {2010},Rebate_Reference = {1}>} [Sales_Value])

I assume that CalendarYear has just integer values and also Rebate_Reference has a value 1.

Hope this helps,

Stefan

Thu, 08 Dec 2011 12:22:44 GMT

Thanks Stefan,

much appreciated