Wildmatch

[Anonymous]

Hi All

Trying to do

Where Wildmatch Field <> something

e.g

So i have a List of cars

Any cars beginning with F i want to NOT include.

Any help would be appreciated......Sunny before you post, im guessing you will....Thanks in advanced!

[sunny_talwar · Accepted solution]

May be this:

Where Left(Cars, 1) <> 'F';

UPDATE:

"Sunny before you post, im guessing you will...."

[Anonymous]

Damn you are fast!! Thanks Buddy!

[sunny_talwar]

No problem

[its_anandrjs]

Try this ways

Data:

LOAD * Inline

[

CarType

Ferari

Fantom

Maruti

Belino

Zen

];

NoConcatenate

Load

*

Resident Data

Where Not WildMatch(CarType,'F*');

DROP Table Data;

Answer you get only

Belino

Maruti

Zen

Regards

Anand

[Anonymous]

Sunny how do you send a PM?

i wanted to ask you a question regarding a dashboard i have been stuck on for a while

Attached a Screen shot

My dimensions are Dept and Month

And Expression is count of DCF...(As you can see in screenshot)

But i keep Getting 100% for all three months in total, Jan Feb March

How can i get 100% per each month?

[sunny_talwar]

What is your expression right now?

[Anonymous]

Dimesiona are:

OpenMonth

=if(DeptNotNeeded <>'1', Dept)

Expression is

=count({<OpenYear = {'2016'}>}DCF)/count(TOTAL{<OpenYear = {'2016'}>}DCF)

[sunny_talwar]

May be this:

=Count({<OpenYear = {'2016'}>}DCF)/Count(TOTAL <Dept> {<OpenYear = {'2016'}>}DCF)

=Count({<OpenYear = {'2016'}>}DCF)/Count(TOTAL <OpenMonth> {<OpenYear = {'2016'}>}DCF)

[Anonymous]

I want to send pm where do i go to do this please?

Thanks