report filrering

[mohanrajsubrama]

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.

[nizamsha]

load

custno

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

[Sokkorn]

Hi Mohanraj,

You need to use calcualted dimension. Here is an example

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

Regards,

Sokkorn

[#4]

try this updated code

load

*

from table

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

[mohanrajsubrama]

It Did not worked out guys .any more ideas

Regards,

Mohanraj Subramanian.

[Sokkorn]

Hi Mohanraj,

Can you attachd sample app here?

Regards,

Sokkorn

[sivarajs]

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

[mohanrajsubrama]

Problem Resolved guys thanks for all for quick reply.

i used this code

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

Regards,

Mohanraj Subramanian.