topic Re: filtering in QlikView

filtering

janardhan — Thu, 01 Nov 2012 09:45:02 GMT

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

Re: filtering

Thu, 01 Nov 2012 09:50:48 GMT

in ur expression tab give expression like this

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

Re: filtering

Anonymous — Thu, 01 Nov 2012 09:50:54 GMT

hi janardhan

u can use d following:

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

Re: filtering

jagan — Thu, 01 Nov 2012 10:12:29 GMT

Hi Janardhan,

Try like this

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

Hope this helps you.

Regards,

Jagan.

Re: filtering

janardhan — Thu, 01 Nov 2012 10:20:36 GMT

Hi Jagan,

i tried but it is showing blank

Re: filtering

jagan — Thu, 01 Nov 2012 10:23:10 GMT

Hi Janardhan,

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

Regards,

Jagan.

Re: filtering

Thu, 01 Nov 2012 10:23:20 GMT

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

Re: filtering

Gysbert_Wassenaar — Thu, 01 Nov 2012 10:28:04 GMT

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)

Re: filtering

Thu, 01 Nov 2012 10:33:52 GMT

Try ...

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

Re: filtering

janardhan — Thu, 01 Nov 2012 10:45:27 GMT

Thanks Wassenaar , its working