topic Re: data filter in straight table in QlikView

data filter in straight table

Wed, 25 Nov 2020 16:16:04 GMT

hi all

i have small query in my tables please tell me any one. the query

name address 1 2 3 4 5 6 7 8

-------- ----------- ---- --- --- --- ---- --- --- ---

a abcd n n n n n n n n

b dcba f f f f f f f f

c gnd n n n n n n n n

d ssss f f f f f f f f

e wwww n n n n n n n n

f rerer f f f f f f f f

i want out blow please observe.

name address 1 2 3 4 5 6 7 8

-------- ----------- --- --- --- --- --- --- --- ---

a abcd n n n n n n n n

c gnd n n n n n n n n

e wwww n n n n n n n n

is their any script or images or files please forward me.

thanks

subbu

Re: data filter in straight table

vinieme12 — Sat, 02 Jul 2016 08:39:47 GMT

Hi ,

It Seems Like you want to suppress specific names in your straight table

Use the below in your dimension

=if(wildmatch(name,'a','c','e')>0,name)

and then Check Suppress when Value is Null

Re: data filter in straight table

muthukumar77 — Mon, 04 Jul 2016 05:17:40 GMT

Hi,

Try like this,

Dimension: Name and Address

Expressions:

Sum({<1={'n'}>}1)

Sum({<2={'n'}>}2)

Sum({<3={'n'}>}3)

Sum({<4={'n'}>}4)

Sum({<5={'n'}>}5)

Sum({<6={'n'}>}6)

Sum({<7={'n'}>}7)

Sum({<8={'n'}>}8)

Re: data filter in straight table

vinieme12 — Mon, 04 Jul 2016 05:58:00 GMT

Hi, can you please post a sample of the data? So people here can help you better.

Cheers

Re: data filter in straight table

vinieme12 — Wed, 06 Jul 2016 15:50:37 GMT

Hi,

Please see attached.