topic Re: Expression Help in QlikView

Expression Help

sona_sa — Wed, 07 Jan 2015 18:54:38 GMT

Hi,

I have an expression i.e :

=
if(GetSelectedCount(Section1=1),

(If(([P&L Level] = 's' or IsAdjustment = '1'), ' ',Sum({Period_1<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName,Section1=$::Section1>}($(OpenBalanceExpression)+($(DebitExpression)-$(CreditExpression)))))),

If(([P&L Level] = 's' or IsAdjustment = '1') , ' ',sum({Period_1<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(OpenBalanceExpression)+($(DebitExpression)-$(CreditExpression)))))
)

Where I have to put a condition for OpenBalanceExpression that is :

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

Only for OpenBalanceExpression

And I have written on variable

OpenBalanceExpression = OpenBal

DebitExpression = Debit

CreditExpression = Credit

Thanks.

Re: Expression Help

Peter_Cammaert — Wed, 07 Jan 2015 22:17:36 GMT

If I get it right, you can go ahead like this:

Divide each Sum({SetAnalysis} OpenBalance + DebitExpr - CreditExpr) sub-expression into three separate subexpressions, like Sum({SetAnalysis} OpenBalance) + Sum({SetAnalysis} DebitExpr) - Sum({SetAnalysis} CreditExpr)Copy the set modifiers to each new subexpression.
Then add the extra set modifier MonthNum={$(vMinMonth)} to the first Sum() only.

Best,

Peter

Re: Expression Help

sona_sa — Thu, 08 Jan 2015 08:55:40 GMT

Thanks Peter.

I accept the point for the same : Sum({SetAnalysis} OpenBalance) + Sum({SetAnalysis} DebitExpr) - Sum({SetAnalysis} CreditExpr)

Can you help me to make the same expression by using all parameter. I am using alternate states so that I am not able to make it.

My Expression :-

If(([P&L Level] = 's' or IsAdjustment = '1'), ,Sum({Period_1<CompanyName=$::CompanyName>}($(OpenBalanceExpression)+($(DebitExpression)-$(CreditExpression)))))

Thanks Again.