Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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