topic Re: Variable in set analysis in QlikView https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310437#M407428 <HTML><HEAD></HEAD><BODY><P>That didn't work - I am still getting the forecast for the whole day.</P></BODY></HTML> Thu, 30 Mar 2017 13:19:36 GMT 2017-03-30T13:19:36Z Variable in set analysis https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310435#M407426 <HTML><HEAD></HEAD><BODY><P>I have this scenario for contact centre.</P><P>We have forecast data found in an Excel spreadsheet and we gather data from our telephony system to get actual data.</P><P></P><P>I want to display in a table the forecast and the actual as the day goes by. We get actual data by 15 mins interval but when I am doing it this way the forecast is showing me for the whole day and not up to the interval for which we have actual data. I thought I could use a variable in set analysis to sum only the forecast data up to the max interval we received - something like</P><P></P><P>sum({&lt;IntervalStart = {"&lt;$(=vMaxInterval)"}&gt;}Forecast)</P><P></P><P>where vMaxInterval is a variable for max(IntervalStart). </P><P></P><P>The above isn't working as expected. </P><P></P><P>Any help or advice will be appreciated.</P><P></P><P>Thanks,</P><P>Amit</P></BODY></HTML> Thu, 30 Mar 2017 13:10:26 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310435#M407426 2017-03-30T13:10:26Z Re: Variable in set analysis https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310436#M407427 <HTML><HEAD></HEAD><BODY><P>How about this may be?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Sum({&lt;IntervalStart = {"&lt;$(=<SPAN style="color: #ff0000;">$(</SPAN>vMaxInterval<SPAN style="color: #ff0000;">)</SPAN>)"}&gt;}Forecast)</STRONG></SPAN></P></BODY></HTML> Thu, 30 Mar 2017 13:16:35 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310436#M407427 sunny_talwar 2017-03-30T13:16:35Z Re: Variable in set analysis https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310437#M407428 <HTML><HEAD></HEAD><BODY><P>That didn't work - I am still getting the forecast for the whole day.</P></BODY></HTML> Thu, 30 Mar 2017 13:19:36 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310437#M407428 2017-03-30T13:19:36Z Re: Variable in set analysis https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310438#M407429 <HTML><HEAD></HEAD><BODY><P>How does <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">IntervalStart </STRONG>look like? Is it a date field or time field? You get forecast for the whole day? It seems that you are doing &lt; Max... so I expect that you want the whole of the period, no?</P></BODY></HTML> Thu, 30 Mar 2017 13:22:10 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310438#M407429 sunny_talwar 2017-03-30T13:22:10Z Re: Variable in set analysis https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310439#M407430 <HTML><HEAD></HEAD><BODY><P>Try Below.</P><P></P><P>sum({&lt;IntervalStart = {"&lt;=$(=vMaxInterval)"}&gt;}Forecast)</P></BODY></HTML> Thu, 30 Mar 2017 13:23:25 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310439#M407430 krishnacbe 2017-03-30T13:23:25Z Re: Variable in set analysis https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310440#M407431 <HTML><HEAD></HEAD><BODY><P>vMaxInterval is something like 03/30/2017 09:00</P><P></P><P>When I make a day selection for today 03/30 - then it should count for intervals starting from midnight to 9:00 (which is the max interval we have actual call data).</P></BODY></HTML> Thu, 30 Mar 2017 13:33:15 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310440#M407431 2017-03-30T13:33:15Z Re: Variable in set analysis https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310441#M407432 <HTML><HEAD></HEAD><BODY><P>That doesnt work as well - still giving me the full day's total forecast.</P></BODY></HTML> Thu, 30 Mar 2017 13:33:36 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310441#M407432 2017-03-30T13:33:36Z Re: Variable in set analysis https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310442#M407433 <HTML><HEAD></HEAD><BODY><P>Hi Amit,</P><P>Can you please elaborate with sample data. </P></BODY></HTML> Fri, 31 Mar 2017 08:48:45 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis/m-p/1310442#M407433 2017-03-31T08:48:45Z