topic Re: Expression help with if in QlikView

Expression help with if

Wed, 25 Nov 2020 16:16:04 GMT

=sum(if([Expense Month-Year]='Mar-2016' ,

if([Expense Month-Year]='Apr-2016',

(Aggr((Max([Amount of Expense]) * Pick(Match(pay_frequency, 'Monthly', 'Quarterly', 'Annually', 'Semi Annually','One Time'), 12, 4, 1, 2,1)),%SubspaceKey,[Expense Type],%ExpenseKey))))

but the below expresson with one if is working fine.

=sum(if([Expense Month-Year]='Mar-2016' ,

(Aggr((Max([Amount of Expense]) * Pick(Match(pay_frequency, 'Monthly', 'Quarterly', 'Annually', 'Semi Annually','One Time'), 12, 4, 1, 2,1)),%SubspaceKey,[Expense Type],%ExpenseKey)))

How can I put it for multiple if's.Thank you.

Re: Expression help with if

sunny_talwar — Fri, 04 Mar 2016 17:41:22 GMT

Sure, try this:

Sum(If(Match([Expense Month-Year], 'Mar-2016', 'Apr-2016'),

Aggr((Max([Amount of Expense]) * Pick(Match(pay_frequency, 'Monthly', 'Quarterly', 'Annually', 'Semi Annually','One Time'), 12, 4, 1, 2,1)),%SubspaceKey,[Expense Type],%ExpenseKey)))

Re: Expression help with if

Fri, 04 Mar 2016 17:49:39 GMT

Its returning 0

Re: Expression help with if

sunny_talwar — Fri, 04 Mar 2016 17:54:21 GMT

Are you using this in a chart or text box object?

Re: Expression help with if

Fri, 04 Mar 2016 18:06:01 GMT

In charts..Bar chart,straight table

Re: Expression help with if

sunny_talwar — Fri, 04 Mar 2016 18:10:21 GMT

Would it be possible to share a sample?