Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Script

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 ,Iperfo.PNG

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

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

];

View solution in original post

13 Replies
vinieme12
Champion III
Champion III

LOAD *

FROm XXXXXX

where wildmatch(Team,'*iperformance*')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

Or

Where Team Like '*Iperformance*';

smilingjohn
Specialist
Specialist
Author

Hi sunny ,

will this sort all that teams which has iPerformance ?

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

smilingjohn
Specialist
Specialist
Author

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 .

vinieme12
Champion III
Champion III

use

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
smilingjohn
Specialist
Specialist
Author

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

vishsaggi
Champion III
Champion III

Extending Vineeth's Script you can try like:

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

sasiparupudi1
Master III
Master III

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

];

MarcoWedel

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