how to set part of the field as dimension

[Anonymous]

I have a table with one field with the value as

fruit - apple

fruit - banana

vege - cabbage

vege - carrot

how can i set the dimension only fruit and vege, which is the first part before the sign '-'?

[neelamsaroha157]

You can create a dimension in your script as

Left(FieldName, Trim(Index(FieldName, ' ',1))) as FriutType

and then use that in front end.

[vishsaggi]

May be try this:

LOAD SubField(Dim1, '-', 1) AS Dim2;

LOAD * INLINE [

Dim1

fruit - apple

fruit - banana

vege - cabbage

vege - carrot

];

[stigchel · Accepted solution]

You can use

=Subfield(Label,' - ',1)

in both script and front end, but it would be better to use it in the script

[sunny_talwar]

You can read more about SubField here:

The Secret Life of SubField‌ and

SubField ‒ QlikView

[Anonymous]

Thanks a lot!

[Anonymous]

Thank you very much.

[Anonymous]

Really appreciate! i used it in calculated dimension and it works!

[Anonymous]

nice! thank you!