topic Re: Between set analysis in QlikView https://community.qlik.com/t5/QlikView/Between-set-analysis/m-p/26359#M4398 <HTML><HEAD></HEAD><BODY><P>=SUM({&lt;periode = {'&gt;=$(=Max(periode)-5)&lt;=$(=Max(periode))'}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, source = { '12'}</SPAN>&gt;}Bedrag)</P></BODY></HTML> Wed, 31 Jan 2018 10:08:16 GMT MK_QSL 2018-01-31T10:08:16Z Between set analysis https://community.qlik.com/t5/QlikView/Between-set-analysis/m-p/26358#M4397 <HTML><HEAD></HEAD><BODY><P><SPAN style="vertical-align: inherit;">Ik wil één periode nummer in mijn ListBox selecteren, zodat ik de laatste 6 maand te selecteren.</SPAN></P><P></P><P><SPAN style="vertical-align: inherit;">Het selecteren periode van 12 dan wil ik de informatie van de periode 7,8,9,10,11 en 12 te zien.</SPAN></P><P><SPAN style="vertical-align: inherit;">Ik probeer dit:</SPAN></P><P><SPAN style="vertical-align: inherit;">Som ({$ &lt;periode = { "$ (&gt; = &amp; (Max (periode) -5) &amp; &lt;= &amp; (Max (periode))"}, source = { '12'}&gt;} Bedrag)</SPAN></P></BODY></HTML> Wed, 31 Jan 2018 09:53:06 GMT https://community.qlik.com/t5/QlikView/Between-set-analysis/m-p/26358#M4397 ahamers 2018-01-31T09:53:06Z Re: Between set analysis https://community.qlik.com/t5/QlikView/Between-set-analysis/m-p/26359#M4398 <HTML><HEAD></HEAD><BODY><P>=SUM({&lt;periode = {'&gt;=$(=Max(periode)-5)&lt;=$(=Max(periode))'}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, source = { '12'}</SPAN>&gt;}Bedrag)</P></BODY></HTML> Wed, 31 Jan 2018 10:08:16 GMT https://community.qlik.com/t5/QlikView/Between-set-analysis/m-p/26359#M4398 MK_QSL 2018-01-31T10:08:16Z Re: Between set analysis https://community.qlik.com/t5/QlikView/Between-set-analysis/m-p/26360#M4399 <HTML><HEAD></HEAD><BODY><P>better to use double quotes for search string now since this has been corrected now</P><P><A href="https://community.qlik.com/qlik-blogpost/5335">Quotes in Set Analysis</A></P></BODY></HTML> Wed, 31 Jan 2018 12:48:28 GMT https://community.qlik.com/t5/QlikView/Between-set-analysis/m-p/26360#M4399 sunny_talwar 2018-01-31T12:48:28Z