Set analysis pb

[#1]

Hi guys,

MAy I have your help for a simple problem  I don't understand it doesn't work.

I want to use Set analysis to dosplay the value of N-1 starting for a selected date (from an island table)

Sales for year is  sum(Sales)

Sales for previous year should be . sum({$<SalesYear = {$(=Only(Cal_An)-1)}>} Sales)

Cal_An is the year which result from a Cal_Date selection (01/05/2012)  and gives only 1 value (2012) and it is stored in an island table detached from other tables.

Nevertheless I 've the same prblem with YTD

I would appreciate an precious help

Thanks

Chris

[#2]

I'm doing it

christian

Selon adrianoalmeida <qliktech@sgaur.hosted.jivesoftware.com>:

adrianoalmeida created

the discussion

"Re: Set analysis pb"

To view the discussion, visit:

http://community.qlik.com/message/235256#235256

[#3 · Accepted solution]

Hi guys,

Thnak you to everybody for having participate to solve this problem.

I finally found the right syntax

sum( {<SalesYear= {'$(=only(Cal_An))'} >} SalesUN)

Means I get all the sales YTD from january to last known month

Best regards

Christian

Selon Michael Solomovich <qliktech@sgaur.hosted.jivesoftware.com>:

Michael Solomovich created

the discussion

"Re: Set analysis pb"

To view the discussion, visit:

http://community.qlik.com/message/235515#235515