tag:blogger.com,1999:blog-2268159193748171866.post5953377893539573297..comments2023-08-16T08:53:49.845+01:00Comments on Qlik Tips: AND Mode in Set AnalysisStephen Redmondhttp://www.blogger.com/profile/10815476951939159307noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2268159193748171866.post-90869572686048236372015-09-28T15:03:22.327+01:002015-09-28T15:03:22.327+01:00It didn't!!!It didn't!!!Anonymoushttps://www.blogger.com/profile/02471194672398031074noreply@blogger.comtag:blogger.com,1999:blog-2268159193748171866.post-70072895301550266392015-09-28T15:03:06.850+01:002015-09-28T15:03:06.850+01:00Hi Stephen,
I've tried to post a comment but t...Hi Stephen,<br />I've tried to post a comment but the set analysis isn't being accepted the way I'm pasting it in. In the set analysis I'm using a union of three set modifiers of the form })>.<br /><br />I hope this post goes in the way I typed it!<br /><br />AndrewAnonymoushttps://www.blogger.com/profile/02471194672398031074noreply@blogger.comtag:blogger.com,1999:blog-2268159193748171866.post-31110086201200001892015-09-28T14:58:50.541+01:002015-09-28T14:58:50.541+01:00Hi Stephen,
Sorry for coming to this late. I'm...Hi Stephen,<br />Sorry for coming to this late. I'm new around here but this seems to work without using AND mode:<br /><br />=sum({$})>*})>*})>}Sales)<br /><br />Your solution is better in as much as it is easier to develop into a more general solution for more than three years but the above formula could still be made a bit more flexible using variables for the years, perhaps to select for three years previous to a selection.<br /><br />Cheers<br /><br />Andrew WalkerAnonymoushttps://www.blogger.com/profile/02471194672398031074noreply@blogger.com