topic Re: Please describe. in QlikView https://community.qlik.com/t5/QlikView/Please-describe/m-p/503854#M1133659 <HTML><HEAD></HEAD><BODY><P>You have to be familiar with the basics of <STRONG>set analysis</STRONG> to understand this.</P><P>It sums the Qty for [Amount Type]-&gt; 'Forecast' <STRONG>ignoring </STRONG>any selection in the fields - [Det Year], [Fiscal Month] for a value [Sale Month] which comes from the variable -vCurrentMonthForecast.</P><P></P><P>Please learn set analysis, it's a VERY IMPORTANT feature of qv. </P></BODY></HTML> Thu, 28 Nov 2013 12:16:18 GMT tresB 2013-11-28T12:16:18Z Please describe. https://community.qlik.com/t5/QlikView/Please-describe/m-p/503853#M1133658 <HTML><HEAD></HEAD><BODY><P>Can someone describe me what does this below expression means.</P><P></P><P>=sum({&lt;[Amount Type]={'Forecast'},[Det Year]=,[Fiscal Month]=,[Sale Month]={$(vCurrentMonthForecast)} &gt;} Qty)</P></BODY></HTML> Thu, 28 Nov 2013 12:09:22 GMT https://community.qlik.com/t5/QlikView/Please-describe/m-p/503853#M1133658 suvechha_b 2013-11-28T12:09:22Z Re: Please describe. https://community.qlik.com/t5/QlikView/Please-describe/m-p/503854#M1133659 <HTML><HEAD></HEAD><BODY><P>You have to be familiar with the basics of <STRONG>set analysis</STRONG> to understand this.</P><P>It sums the Qty for [Amount Type]-&gt; 'Forecast' <STRONG>ignoring </STRONG>any selection in the fields - [Det Year], [Fiscal Month] for a value [Sale Month] which comes from the variable -vCurrentMonthForecast.</P><P></P><P>Please learn set analysis, it's a VERY IMPORTANT feature of qv. </P></BODY></HTML> Thu, 28 Nov 2013 12:16:18 GMT https://community.qlik.com/t5/QlikView/Please-describe/m-p/503854#M1133659 tresB 2013-11-28T12:16:18Z Re: Please describe. https://community.qlik.com/t5/QlikView/Please-describe/m-p/503855#M1133660 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can google for QlikView set analysis, but in this thread there are some good links - <A _jive_internal="true" href="https://community.qlik.com/thread/97862">http://community.qlik.com/thread/97862</A></P><P></P><P>Regards</P><P>Steen</P></BODY></HTML> Thu, 28 Nov 2013 12:34:11 GMT https://community.qlik.com/t5/QlikView/Please-describe/m-p/503855#M1133660 sspe 2013-11-28T12:34:11Z Re: Please describe. https://community.qlik.com/t5/QlikView/Please-describe/m-p/503856#M1133661 <HTML><HEAD></HEAD><BODY><P>I <SPAN class="short_text" lang="en"><SPAN class="hps">recommend you see also <STRONG>Alternate State</STRONG>, because it's another very important feature of qlikview that allow you to work with different selections for same field, useful for chart comparisons in my scenarios.<BR />Regards<BR /></SPAN></SPAN></P></BODY></HTML> Thu, 28 Nov 2013 13:23:35 GMT https://community.qlik.com/t5/QlikView/Please-describe/m-p/503856#M1133661 2013-11-28T13:23:35Z