Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
load
custno
from table where not( wildmatch(custno,'C*','R'))
Hi Mohanraj,
You need to use calcualted dimension. Here is an example
If(WildMatch([customer no],'CA*','CN*','R*'),Null(),[customer no])
Regards,
Sokkorn
try this updated code
load
*
from table
where not wildmatch(custno,'C*','R');
It Did not worked out guys .any more ideas
Regards,
Mohanraj Subramanian.
Hi Mohanraj,
Can you attachd sample app here?
Regards,
Sokkorn
LOAD * from test.qvd where not WildMatch(left(CustomerNo,2),'CN','CA','R*');
Problem Resolved guys thanks for all for quick reply.
i used this code
=if(num([Customer No_])>0,[Customer No-],null())
Regards,
Mohanraj Subramanian.