This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a field which has string values. I want to create a field flag if any of the values contain the word 'enter'.
This new field should seperate all values that do/dont have enter in them
How about this?
If(Index(Location,'enter'), Location) as Enter_Location
View solution in original post
In your load script try if(match('enter ',' enter'),'Y','N') as Flag this way you will capture locations that have space before the word enter or after. If there is no space after the word just amend to 'enter'
Hi Thanks for your response.
Where do i use the field [location]?
May be try this?
IF(Wildmatch(Location, '*enter*') >0, Location) AS EnterLocation