topic Re: EXPRESSION HELP PLEASE in QlikView

EXPRESSION HELP PLEASE

Thu, 25 Feb 2016 16:13:20 GMT

=IF(GetSelectedCount(LuCurrencyType3) > 0,

sum(IF(wildmatch([Type],'*Book*')=1,[Amount ]*Factors3)/Factors3),

sum(IF(wildmatch([Type],'*Book*')=1,[Amount ]*Factors3)))

Is there anything wrong in the above expression.

Below expression is working fine but when I add If to filter out amount for book it is not working.Is there any other way to write the above expression?

=IF(GetSelectedCount(LuCurrencyType3) > 0,

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

sum([Expense]*Factors))

Re: EXPRESSION HELP PLEASE

sunny_talwar — Thu, 25 Feb 2016 16:15:24 GMT

May be this:

=IF(GetSelectedCount(LuCurrencyType3) > 0,

sum(IF(wildmatch([Type],'*Book*')=-1,[Amount ]*Factors3)/Factors3),

sum(IF(wildmatch([Type],'*Book*')=-1,[Amount ]*Factors3)))

=IF(GetSelectedCount(LuCurrencyType3) > 0,

sum({<Type = {'*Book*'}>} [Amount ]*Factors3)/Factors3),

sum({<Type = {'*Book*'}>}[Amount ]*Factors3)))

UPDATE: I would suggest using the set analysis method rather than if statement (2nd expression above)

Re: EXPRESSION HELP PLEASE

cesaraccardi — Thu, 25 Feb 2016 16:17:10 GMT

Hi,

Yes you could use set analysis.

=IF(GetSelectedCount(LuCurrencyType3) > 0,

sum({$<Type={'*Book*'}>} [Expense]*Factors)/[Factors3],

sum({$<Type={'*Book*'}>} [Expense]*Factors))

Re: EXPRESSION HELP PLEASE

Thu, 25 Feb 2016 17:25:56 GMT

Thank to you as always !

Re: EXPRESSION HELP PLEASE

sunny_talwar — Thu, 25 Feb 2016 17:28:09 GMT

No problem