topic Re: Script in QlikView

Script

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have a field called Team, within the field name i have many contentes and among which i have to select those which has Iperformance ,

Please find the attachment .. can some one tell me how do i write in the script to get those Team which has iperformance in it .

and Iperformance

Regards ,

Re: Script

vinieme12 — Thu, 23 Mar 2017 14:30:02 GMT

LOAD *

FROm XXXXXX

where wildmatch(Team,'*iperformance*')

Re: Script

sunny_talwar — Thu, 23 Mar 2017 14:39:27 GMT

Where Team Like '*Iperformance*';

Re: Script

smilingjohn — Thu, 23 Mar 2017 14:45:58 GMT

Hi sunny ,

will this sort all that teams which has iPerformance ?

for example 303eiPerformance,201e iPerformanceXVDef, X5 iPerformance, ......and so on ?

Re: Script

smilingjohn — Thu, 23 Mar 2017 14:52:26 GMT

And also iam creating a flag and iam using this , if the content under field team is Iperformance then it should be 1 else 0 ,

is this correct iam trying to use the flag ?

if(Team='*iperformance*',1,0) as iPerf,

But this is not working, after taking the filter as a list box it shows only 0 .

Re: Script

vinieme12 — Thu, 23 Mar 2017 15:06:06 GMT

use

Wildmatch(Team,'*iperformance*') as iPerf,

Re: Script

smilingjohn — Thu, 23 Mar 2017 15:07:37 GMT

Hi Vineet ,

but how do i create the flag for the same , with 1 and 0 ,

That is there should be a flage if the teams has Iperformance then it should slecte as 1 else 0

Re: Script

vishsaggi — Thu, 23 Mar 2017 15:12:14 GMT

Extending Vineeth's Script you can try like:

IF(Wildmatch(Team,'*iperformance*') > 0, 1, 0) as iPerfFlag,

Re: Script

sasiparupudi1 — Thu, 23 Mar 2017 20:22:21 GMT

Like this may be?

Table:

Load

Id,

Team,

if(SubStringCount(lower(Team),'iperformance')>0,1,0) as IsValueAvailable;

LOAD * INLINE [

Id,Team

1,324e iperformance Test Drive

82,328e Iperformance

99,330e Iperformance

100,330e Sedan Iperformance

180,530e Iperformance

181,530e Xdrive Iperformance

182,530e Xdrive iperformance

183,530e Xdrive

];

Re: Script

MarcoWedel — Thu, 23 Mar 2017 23:56:03 GMT

that's what the proposed expression should deliver ...

Re: Script

MarcoWedel — Thu, 23 Mar 2017 23:57:15 GMT

another solution might be:

-(Team like '*iperformance*') as iPerf

hope this helps

regards

Marco

Re: Script

vinieme12 — Fri, 24 Mar 2017 09:03:00 GMT

Hi,

Wildmatch returns a number if it finds the search string it will return 1 else 0, so we don't need to encapsulate it in an if() statement.... try it first

Re: Script

vinieme12 — Fri, 24 Mar 2017 10:15:04 GMT

Hi,

Wildmatch returns a number if it finds the search string it will return 1 else 0, so we don't need to encapsulate it in an if() statement.... try it first

LOAD *,wildmatch(Team,'*iperf*') as iPer_flag INLINE [

Id,Team

1,324e iperformance Test Drive

82,328e Iperformance

99,330e Iperformance

100,330e Sedan Iperformance

180,530e Iperformance

181,530e Xdrive Iperformance

182,530e Xdrive iperformance

183,530e Xdrive

];

Re: Script

MarcoWedel — Sun, 26 Mar 2017 21:51:45 GMT

comparison of the different proposed solutions:

LOAD Team,
     WildMatch(Team,'*iperformance*') as iPer_flag,
     If(SubStringCount(Lower(Team),'iperformance')>0,1,0) as IsValueAvailable,
     -(Team like '*iperformance*') as iPerf      
INLINE [
    Team
    324e iperformance Test Drive
    328e Iperformance
    330e Iperformance
    330e Sedan Iperformance
    530e Iperformance
    530e Xdrive Iperformance
    530e Xdrive iperformance
    530e Xdrive
];

hope this helps

regards

Marco