topic Re: How to filter more then 1 items ? in QlikView

How to filter more then 1 items ?

paulyeo11 — Sat, 04 May 2013 02:43:42 GMT

Hi All

I just Add GL_CODE = 50010 to below expression :-

=money(fabs(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"$(=Date([YearMonth],'YY MMM'))"},[GL_CODE] = {"50010"}, month = ,year=>}[Amount])), $(vCurrency)))

I need to Add one more GL_CODE = 50011 , may i know how to add ? so that my SET expression will filter 50010 and 50011.

Paul

Re: How to filter more then 1 items ?

vivek_niti — Sat, 04 May 2013 02:56:10 GMT

Hi,

Try this...

=money(fabs(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"$(=Date([YearMonth],'YY MMM'))"},[GL_CODE] = {"50010","50011"}, month = ,year=>}[Amount])), $(vCurrency)))

Regards,

Re: How to filter more then 1 items ?

Sokkorn — Sat, 04 May 2013 04:25:54 GMT

Hi Paul,

It seem that your GL code is a number. Let try

[GL_CODE] = {50010,50011}

Regards,

Sokkorn

Re: How to filter more then 1 items ?

paulyeo11 — Sat, 04 May 2013 06:49:11 GMT

Hi Vivek

Thank you vrey much your working.

Thank you Sokkom for good try.

Paul

Re: How to filter more then 1 items ?

er_mohit — Sat, 04 May 2013 06:50:14 GMT

You simply write this way

[GL_CODE] = {50010,50011}

Re: How to filter more then 1 items ?

paulyeo11 — Sat, 04 May 2013 07:20:26 GMT

Hi er , Thank you very much , it work fine . since i need to filter GL Code from 50010 till 50030, meaning total 20 number , how to avoid writing all the individual number , and just use from 50010 till 50030 , it there have such code in QV ?

Paul

Re: How to filter more then 1 items ?

paulyeo11 — Sat, 04 May 2013 07:22:53 GMT

my QV Doc

Re: How to filter more then 1 items ?

er_mohit — Sat, 04 May 2013 11:24:43 GMT

Sorry for late reply.

For this situation you could try like this

and i can't open your app. coz, i m working on personal edition..

[GL_CODE] = {">=50010<=50030"}

Re: How to filter more then 1 items ?

paulyeo11 — Sat, 04 May 2013 19:44:15 GMT

Hi er

your suggestion work fine . many thank it make my life easy.

Paul