topic Re: Use of Set Modifier with As Of-Table in QlikView https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986505#M952280 <HTML><HEAD></HEAD><BODY><P>Many thanks Sunny, please find attached.</P><P></P><P>The chart in the second tab in container is the one which i am referring to.&nbsp; The chart in the first tab of the containers has no set modifiers.</P><P></P><P>Regards.</P></BODY></HTML> Wed, 25 Nov 2015 21:50:12 GMT Anonymous 2015-11-25T21:50:12Z Use of Set Modifier with As Of-Table https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986503#M952277 <HTML><HEAD></HEAD><BODY><P>Can one use a set modifier with the As Of-Table as follows:</P><P></P><P> <SPAN lang="EN-US" style="font-size: 13.0pt; font-family: 'Helvetica Neue'; color: #2e2e2e;">Sum({$&lt;MonthDiff={"&lt;12"}, [Generic Drug Indicator] = {'YES'}&gt;} Amount)</SPAN></P><P></P><P>The above gives me values lower than expected.</P><P></P><P>Regards.</P></BODY></HTML> Wed, 25 Nov 2015 21:08:05 GMT https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986503#M952277 Anonymous 2015-11-25T21:08:05Z Re: Use of Set Modifier with As Of-Table https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986504#M952279 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample?</P></BODY></HTML> Wed, 25 Nov 2015 21:09:10 GMT https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986504#M952279 sunny_talwar 2015-11-25T21:09:10Z Re: Use of Set Modifier with As Of-Table https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986505#M952280 <HTML><HEAD></HEAD><BODY><P>Many thanks Sunny, please find attached.</P><P></P><P>The chart in the second tab in container is the one which i am referring to.&nbsp; The chart in the first tab of the containers has no set modifiers.</P><P></P><P>Regards.</P></BODY></HTML> Wed, 25 Nov 2015 21:50:12 GMT https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986505#M952280 Anonymous 2015-11-25T21:50:12Z Re: Use of Set Modifier with As Of-Table https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986506#M952281 <HTML><HEAD></HEAD><BODY><P>I guess I need to ask you what is the expected value? Right now we have these, what would you want them to be?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107222_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2015 21:55:04 GMT https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986506#M952281 sunny_talwar 2015-11-25T21:55:04Z Re: Use of Set Modifier with As Of-Table https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986507#M952283 <HTML><HEAD></HEAD><BODY><P>Many thanks Sunny, i realised that my dimension was wrong it was MonthYear instead of AsOfMonths</P></BODY></HTML> Wed, 25 Nov 2015 22:13:06 GMT https://community.qlik.com/t5/QlikView/Use-of-Set-Modifier-with-As-Of-Table/m-p/986507#M952283 Anonymous 2015-11-25T22:13:06Z