topic How can i make a specific expression in QlikView

How can i make a specific expression

Tue, 25 May 2010 14:58:06 GMT

Hi,

I have a list of email addresses which display the records. For an example

email Name Size

aa1@aa.com aa1 10

abc@aa.com abc 15

aa2@aa.com aa2 20

abc1@abc.com abc 10

Based on "email" field, How can i make a expression to say 'email' does not contain "aa*@"? So it will return the value "abc@aa.com & abc1@aa.com"

Thanks in adavance.

How can i make a specific expression

Tue, 25 May 2010 15:54:15 GMT

Hi dp,

I have not used an expression in the application but instad I have used a macro for the same. Just look whethere it helps you or not. I am pasting a smple application along with this mail.

Thanks joseph.......

How can i make a specific expression

johnw — Tue, 25 May 2010 16:41:23 GMT

Replace the email dimension with this calculated dimension and suppress nulls:

if(not wildmatch(email,'*aa*@*'),email)

How can i make a specific expression

Tue, 25 May 2010 17:05:23 GMT

Thanks Joseph,

I thought about to used a macro for this query.

Thanks,

Dipesh

How can i make a specific expression

Tue, 25 May 2010 17:06:17 GMT

Thanks John,

It works for me.

Much appriciate, Dipesh