topic Re: How to add filter on Reporting Code 1 to 11 into my Expression ? in QlikView

How to add filter on Reporting Code 1 to 11 into my Expression ?

paulyeo11 — Sat, 11 May 2013 15:21:53 GMT

Hi All

I have a Expression which is working fine :-

money(

fabs(

sum(Amount/$(Columndim89))/1000)

, $(vCurrencyFormatK))

How to add below filter into above expression :-

[Reporting Code]

='>=' & 0001 & '<=' & 011

tresB — Mon, 13 May 2013 05:49:45 GMT

Try this:

money(

fabs(
sum( {$<[Reporting Code] = {">=0001<=011"}>} Amount/$(Columndim89), $(vCurrencyFormatK))

Thanks.

paulyeo11 — Mon, 13 May 2013 11:51:09 GMT

Hi Tresesco

Thank you very much . it work.

Paul