topic Re: starts with function in QlikView

starts with function

master_student — Wed, 23 Aug 2017 11:03:21 GMT

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 — Wed, 23 Aug 2017 11:09:16 GMT

Try with

Load

From Location

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

its_anandrjs — Wed, 23 Aug 2017 11:15:06 GMT

And for your script

Load

From Location

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

Kushal_Chawda — Wed, 23 Aug 2017 11:17:50 GMT

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 — Wed, 23 Aug 2017 11:39:23 GMT

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'