Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mohanrajsubrama
New Contributor II

report filrering

Hi Guys,

               I am having a pivot table having these columns.Now my requirement is i dont want to see customer number  which starts from CA,CN,R.How do i implement this in qlikview

group    sub-group    customer no    customername     actual     budget

                                    111                 abc

                                      234                 j

                                       345               k

                                   CN                    l

                                    CA                   m

                                    R                      n

Regards,

Mohanraj Subramanain.

7 Replies
nizamsha
Valued Contributor

Re: report filrering

load

custno

from table where not( wildmatch(custno,'C*','R'))

Sokkorn
Honored Contributor

Re: report filrering

Hi Mohanraj,

You need to use calcualted dimension. Here is an example

If(WildMatch([customer no],'CA*','CN*','R*'),Null(),[customer no])

Regards,

Sokkorn

Not applicable

Re: report filrering

try this updated code

load

*

from table

where not  wildmatch(custno,'C*','R');

mohanrajsubrama
New Contributor II

Re: report filrering

It Did not worked out guys .any more ideas

Regards,

Mohanraj Subramanian.

Sokkorn
Honored Contributor

Re: report filrering

Hi Mohanraj,

Can you attachd sample app here?

Regards,

Sokkorn

sivarajs
Valued Contributor II

Re: report filrering

LOAD * from test.qvd  where not WildMatch(left(CustomerNo,2),'CN','CA','R*');

mohanrajsubrama
New Contributor II

Re: report filrering

Problem Resolved guys thanks for all for quick reply.

i used this code

=if(num([Customer No_])>0,[Customer No-],null())

Regards,

Mohanraj Subramanian.

Community Browser