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 put 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

vinieme12 — Sat, 02 Jul 2016 08:56:04 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

Mon, 04 Jul 2016 03:45:31 GMT

My dummy method: Straight table, Dimensions: Field "name" to "7" Expression:sum(if(field1 &...field8=n,field8,)) as field 8

vinieme12 — Mon, 04 Jul 2016 13:46:23 GMT

Hi ,

Please see attached QVD for the below. There are two ways in which you can achieve this.