Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

starts with function

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

1 Solution

Accepted Solutions
Kushal_Chawda

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*');

View solution in original post

4 Replies
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

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'