topic Re: Set Analysis Expression Help in QlikView

Set Analysis Expression Help

sona_sa — Thu, 08 Jan 2015 11:28:02 GMT

Hi Friends,

I have an expression which is: If(([P&L Level] = 's' or IsAdjustment = '1'), ,Sum({Period_1<CompanyName=$::CompanyName>}($(OpenBalanceExpression)))

Now I have to add a condition i.e.:

{$<MonthNum= {$(vMinMonth)}>}

How I can implement the same in my expression?

Thanks.

Re: Set Analysis Expression Help

tresB — Thu, 08 Jan 2015 11:36:28 GMT

If the state is same, try like:

If(([P&L Level] = 's' or IsAdjustment = '1'), ,Sum({Period_1<MonthNum= {$(vMinMonth)}, CompanyName=$::CompanyName>}.....

Re: Set Analysis Expression Help

jonathandienst — Thu, 08 Jan 2015 11:36:31 GMT

Your example has syntax errors, so I am not sure exactly what you want:

If(([P&L Level] = 's' or IsAdjustment = '1'), Sum({$<MonthNum = {$(=vMinMonth)}> * Period_1<CompanyName=$::CompanyName>} ($(OpenBalanceExpression))))

or possibly

If(([P&L Level] = 's' or IsAdjustment = '1'), 0, Sum({$<MonthNum = {$(=vMinMonth)}> * Period_1<CompanyName=$::CompanyName>} ($(OpenBalanceExpression))))

HTH

Jonathan

Re: Set Analysis Expression Help

sona_sa — Thu, 08 Jan 2015 12:24:05 GMT

Hi Jonathan,

Thanks....

I have used the same expression. But it is giving the output 0. But There is +ve and -ve values are there in database.

For ref. Please check the Table I have provided there in QVW. Also please find the attached qvw for more ref.

Thanks again for reply.