Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a list box, I want it to only show records starting with BEL..and exclude all others that don't start with BEL
Lets say the dimension name is MODEL_CODE.
MS
Hi,
Try with this:
If(left(FieldName, 3) = 'BEL', FieldName)
Regards,
Ricardo
Try this expression for the listbox:
=aggr(if(left(MODEL_CODE,3)='BEL',MODEL_CODE),MODEL_CODE)
Hi,
Try with this:
If(left(FieldName, 3) = 'BEL', FieldName)
Regards,
Ricardo
Hi
PFA
Hope it helps
Thank you again Gysbert,
though the solution you gave, eliminates any model other than BEL, but when I make a selection on listbox(with the expression =aggr(if(left(MODEL_CODE,3)='BEL',MODEL_CODE),MODEL_CODE)) ,all the other values disappear, ie only one value appears in the list box, I want the list box to show other BEL models
MS
Remove the aggr: =if(left(MODEL_CODE,3)='BEL',MODEL_CODE)
I tried this code in the script editor
IF(model_code like 'BEL',1,0) as flag_model_code
But the thing is its also showing records starting with "Bel"..I want BEL..and not Bel..cos el is lower case
Hi Mayil,
Thank u , but its not case sensitive, I want it to eliminate "Bel" Cos el is lower case, only records starting with BEL should be fished out.
Can it be done ?
Thanks
SM
HI
Then try like this
If(Left(MODEL_CODE,3)='BEL',MODEL_CODE) As MODEL_CODE
Hope it helps