starts with function

[master_student]

Hello Guys,

I would like to keep only status that starts with the text  'FERME'

is there any function in qlik that do that ?

Thanks

[its_anandrjs]

Try with

Load

*

From Location

Where  Fieldname = Left( Fieldname , 'FERME' );

[its_anandrjs]

And for your script

Load

*

From Location

Where  Left( status , 5) = 'FERME' ;

[Kushal_Chawda · Accepted solution]

If you want to see the status for specific object then you can use the set analysis expression in your chart like below

=sum({<Status ={"FERME*"}>} Sales)

If you just want to keep the status start with FERME in data itself, then you can write the where condition while loading the data

LOAD *

FROM table

WHERE wildmatch(Status ,'FERME*');

[sunny_talwar]

Where do you need this to be done? In a chart or in the script? You can use WildMatch, Like or Left functions to do this

1) WildMatch(Status, 'FERME*')

2) Status Like 'FERME*'

3) Left(Status, 5) = 'FERME'