Difficulty with Set Analysis

Wed, 20 Jan 2010 15:22:21 GMT

This is very odd - I built a set analysis chart and it was working great. Then after a manual reload it stopped working. You can see below with the highlighted examples, that I can get "40187" to work so long I don't do any "math" against it -

Works and evaluates --

=Sum ({$<[DFA_Search.DayNumber]={$(=Only(DFA_Search.DayNumber))}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))

Doesn't work (but I am pretty sure it was at some point)

=Sum ({$<[DFA_Search.DayNumber]={$(=only(DFA_Search.DayNumber)-1)}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))

DFA_Search.DayNumber is defined as --

NUM

(ReportDate) AS 'DayNumber',

Keyword	=Sum ({$<[DFA_Search.DayNumber]={40187}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))	=Sum ({$<[DFA_Search.DayNumber]={40186}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))
	391	0
foo	5	0
foo	1	0
foo	2	0
foo	1	0
foo	2	0
foo	2	0

verses

Keyword	=Sum ({$<[DFA_Search.DayNumber]={40186}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))	=Sum ({$<[DFA_Search.DayNumber]={40185}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))
	466	0
foo	1	0
foo	2	0
foo	2	0
foo	1	0
foo	1	0
foo	4	0

Does anyone have any ideas on if my syntax is wrong or if I am missing something.

Thanks,

Chris

topic Difficulty with Set Analysis in QlikView

Difficulty with Set Analysis