topic Re: Wildmatch in QlikView

Wildmatch

Anonymous — Thu, 10 Mar 2016 15:14:34 GMT

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!

Re: Wildmatch

sunny_talwar — Thu, 10 Mar 2016 15:20:52 GMT

May be this:

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

UPDATE:

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

Re: Wildmatch

Anonymous — Thu, 10 Mar 2016 15:23:28 GMT

Damn you are fast!! Thanks Buddy!

Re: Wildmatch

sunny_talwar — Thu, 10 Mar 2016 15:25:26 GMT

No problem

Re: Wildmatch

its_anandrjs — Thu, 10 Mar 2016 15:28:14 GMT

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

Re: Wildmatch

Anonymous — Mon, 14 Mar 2016 13:40:53 GMT

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?

Re: Wildmatch

sunny_talwar — Mon, 14 Mar 2016 13:42:18 GMT

What is your expression right now?

Re: Wildmatch

Anonymous — Mon, 14 Mar 2016 13:47:05 GMT

Dimesiona are:

OpenMonth

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

Expression is

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

Re: Wildmatch

sunny_talwar — Mon, 14 Mar 2016 13:49:35 GMT

May be this:

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

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

Re: Wildmatch

Anonymous — Mon, 14 Mar 2016 13:51:35 GMT

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

Thanks

Re: Wildmatch

sunny_talwar — Mon, 14 Mar 2016 14:00:00 GMT

I just messaged you, you can respond to my message