Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difficulty with Set Analysis

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

0 Replies