Set Analysis Expression Syntax Issue

lightsection — Fri, 09 Sep 2016 21:40:43 GMT

I am trying to create a dynamic search string in the set analysis expression using variables, but it doesn't seem to work.

I have 2 variables that store the dynamic selections from year and month field, which are then used in the main expression's set analysis.

Variable Definitions:

Let vEP_Month = Chr(39) & Concat(Distinct If(GetSelectedCount(Revenue_Month) = 0, MaxMonthTxt, Revenue_Month) , Chr(39) & ',' & Chr(39)) & Chr(39);

Let vEP_Year = Chr(39) & Concat(Distinct If(GetSelectedCount(Fiscal_Year) = 0, $(MaxYear), Fiscal_Year), Chr(39) & ',' & Chr(39)) & Chr(39);

Variable Outputs:

Expression to calculate Revenue

Sum({<Fiscal_Year = {$(vEP_Year)}, Revenue_Month = {$(vEP_Month)}>} Net_Revenue_YTD)

Re: Set Analysis Expression Syntax Issue

sunny_talwar — Fri, 09 Sep 2016 21:46:28 GMT

Try this:

Sum({<Fiscal_Year = {$(=vEP_Year)}, Revenue_Month = {$(=vEP_Month)}>} Net_Revenue_YTD)

Sum({<Fiscal_Year = {$(=$(vEP_Year))}, Revenue_Month = {$(=$(vEP_Month))}>} Net_Revenue_YTD)

topic Re: Set Analysis Expression Syntax Issue in QlikView

Set Analysis Expression Syntax Issue

Re: Set Analysis Expression Syntax Issue