topic Re: report filrering in QlikView

report filrering

mohanrajsubrama — Fri, 12 Jul 2013 06:59:00 GMT

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.

Re: report filrering

nizamsha — Fri, 12 Jul 2013 07:05:27 GMT

load

custno

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

Re: report filrering

Sokkorn — Fri, 12 Jul 2013 07:07:41 GMT

Hi Mohanraj,

You need to use calcualted dimension. Here is an example

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

Regards,

Sokkorn

Re: report filrering

Fri, 12 Jul 2013 07:13:15 GMT

try this updated code

load

from table

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

Re: report filrering

mohanrajsubrama — Fri, 12 Jul 2013 07:41:12 GMT

It Did not worked out guys .any more ideas

Regards,

Mohanraj Subramanian.

Re: report filrering

Sokkorn — Fri, 12 Jul 2013 07:44:20 GMT

Hi Mohanraj,

Can you attachd sample app here?

Regards,

Sokkorn

Re: report filrering

sivarajs — Fri, 12 Jul 2013 08:34:56 GMT

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

Re: report filrering

mohanrajsubrama — Fri, 12 Jul 2013 08:41:38 GMT

Problem Resolved guys thanks for all for quick reply.

i used this code

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

Regards,

Mohanraj Subramanian.