topic Re: Expression Help in QlikView

Expression Help

Thu, 25 Feb 2016 04:36:50 GMT

=If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016,

(sum([Expense]*Factors)/([Factors3])),

(sum([ Expense]*(Factors))))

Is there anything wrong in the above expression ?

Thank you.

Re: Expression Help

sunny_talwar — Thu, 25 Feb 2016 04:41:08 GMT

May be reduce the excessive use of parenthesis to see if you have extra parenthesis in there:

=If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016,

(sum(Expense*Factors)/[Factors3]),(sum(Expense*Factors)))

Re: Expression Help

HirisH_V7 — Thu, 25 Feb 2016 04:54:56 GMT

Hi,

Check with this Expression,

If(GetSelectedCount(LuCurrencyType3) > 0 ,

(sum({<[Year of Expense]={'2016'}>}[Expense])*Sum({<[Year of Expense]={'2016'}>}Factors))/Sum({<[Year of Expense]={'2016'}>}[Factors3]),
  (sum({<[Year of Expense]={'2016'}>}[Expense])*Sum({<[Year of Expense]={'2016'}>}Factors))

Hope this Helps,

Hirish

Re: Expression Help

Anonymous — Thu, 25 Feb 2016 05:49:37 GMT

may be this?

=If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016,

sum([Expense]*Factors)/[Factors3], sum([ Expense]*Factors))

What issue you are facing??

Are you getting any error as expression looks okay?

Re: Expression Help

Thu, 25 Feb 2016 06:04:59 GMT

Hi Pavana please try this expression.

if(GetSelectedCount(LuCurrencyType)>0 and [Year Of Expense]=2016,

(Sum({$<[Year Of Expense]={'2016'}>Expense})*Sum({$<[Year Of Expense]={'2016'}>Factors}))/Sum({$<[Year Of Expense]={'2016'}>Factors3}),

(Sum({$<[Year Of Expense]={'2016'}>Expense})*Sum({$<[Year Of Expense]={'2016'}>Factors}))

Re: Expression Help

Digvijay_Singh — Thu, 25 Feb 2016 06:27:29 GMT

It appears you have kept Factors3 out of aggregation functions, which needs to be validated through sample data. Check if it should be inside sum or not.

Re: Expression Help

PrashantSangle — Thu, 25 Feb 2016 06:46:09 GMT

Hi,

did you get any error??

Syntax wise, it is correct.

might be issue because of naked expression for Factors3..

Try below,

If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016,

(sum([Expense]*Factors)/sum([Factors3])),

(sum([ Expense]*(Factors))))

Regards

Re: Expression Help

engishfaque — Thu, 25 Feb 2016 06:57:30 GMT

Dear Pavana,

Here is an expression,

Expression 1:

----

=If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense] = 2016,

([Expense]*Factors)/[Factors3],

[Expense]*Factors

)

Expression 2:

----

=If(GetSelectedCount(Len(Trim(LuCurrencyType3))) > 0 and [Year of Expense] = 2016,

([Expense]*Factors)/[Factors3],

[Expense]*Factors

)

Kind regards,

Ishfaque Ahmed

Re: Expression Help

Thu, 25 Feb 2016 14:00:51 GMT

=If(GetSelectedCount(LuCurrencyType3) > 0 ,

sum([Expense]*Factors)/[Factors3],

sum([Expense]*Factors))

The above expression works fine and give me the amount for all the year,where as I want to filter for current year and when I add the Year filter still it shows the amount for all the years.

If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016 ,

sum([Expense]*Factors)/[Factors3],

sum([Expense]*Factors))

If I filter year from list box it will show amount for current year,but I want to do that in expression itself.

None of the above expression is working.Not sure why.Thank to you all though.