topic Re: Urgent help in expression please!! in QlikView

Urgent help in expression please!!

Wed, 14 May 2014 10:01:30 GMT

Hi,

I have address with values as

2343,Gerry street, London

453454,Licd Dale colony, Derry

2565363,Gerry street, London

2354y45y3, Dovey street, London

2346463,Piorh street, London

2343,XXXX, Canada

2343,GRaeybb, Australia

dimension is ID

expression is Address

How can I get the straight table to show the address value which contains only London. could anyone suggest me the expression.

I used the below expression but it is not working.

If(MixMatch([Address],'*London*'),[Address] )

Re: Urgent help in expression please!!

jagan — Wed, 14 May 2014 10:06:43 GMT

Hi,

Try like this

=Only({<Address={'*London*'}>} Address)

Regards,

Jagan.

Re: Urgent help in expression please!!

ashfaq_haseeb — Wed, 14 May 2014 10:09:15 GMT

Hi,

may be like this.

Regards

ASHFAQ

Re: Urgent help in expression please!!

Wed, 14 May 2014 10:10:17 GMT

Thanks. Tried it is showing error in set modifier. Do I need to change any thing?

Re: Re: Urgent help in expression please!!

jagan — Wed, 14 May 2014 10:22:10 GMT

HI,

PFA file for solution.

Regards,

Jagan.

Re: Urgent help in expression please!!

Wed, 14 May 2014 10:25:42 GMT

Thanks perfect.

Re: Urgent help in expression please!!

nizamsha — Wed, 14 May 2014 10:28:06 GMT

Tab:

Load * inline

[

ID,Name,City,Address

2343,Gerry street,London

453454,abc,Licd Dale colony,Derry

2565363,xyz,Gerry street, London

2354y45y3,pqr, Dovey street, London

2346463,qwer,Piorh street, London

2343,aaaa,XXXX, Canada

2343,bbbb,GRaeybb, Australia

];

Expression

only({<Address={'London'}>}Address)