Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>:
the discussion
"Re: Set analysis pb"
To view the discussion, visit:
http://community.qlik.com/message/235515#235515