filtering

[janardhan]

Hi friends ,

i need to display only vlaues of A and B

i tried like this :

=if(worksoft='A' and 'B' , worksoft) ,

=if(worksof='A' and worksoft='B' , worksoft)

but it is not working, can anyone hlep me

[#2]

Hi

in ur expression tab give expression like this

sum({<worksoft={'a','b'}>}value)

[Anonymous]

hi janardhan

              u can use d following:

        only( {<Worksoft=  {A, B} >} Worksoft)

[jagan]

Hi Janardhan,

Try like this

=Match(worksoft, 'Á', 'B')

Hope this helps you.

Regards,

Jagan.

[janardhan]

Hi Jagan,

i tried but it is showing blank

[jagan]

Hi Janardhan,

Can you attach some sample file, where you are using this, are u using this in Dimension?

Regards,

Jagan.

[#7]

Hi Janardhan

use this

it work to me

in ur expression tab give expression like this

sum({<worksoft={'A','B'}>}value)

then it show only A and B values

[Gysbert_Wassenaar · Accepted solution]

For a calculated dimension you can use this:

=if(worksoft='A' or worksoft='B' , worksoft)

of this:

=if(match(worksoft,'A','B'),worksoft)

If you want to limit a listbox, try: (A|B)

[#9]

Try ...

=if(worksoft='A', worksoft, if(worksoft='B', worksoft,'')

[janardhan]

Thanks Wassenaar , its working