Shorten datavalues

Tue, 28 May 2013 09:52:42 GMT

Hello.

I have been working on my first Qlikview course since a couple of days.

I've got a database from my lecturer what I need to work on.

This is in short what the table looks like:

Store Value

Storname1 10

Storename2 32

etc etc

What i whant, is that the storenames start from character 14, because the storenames starting all with the same name, followed by the actual name.
Example:

Milkshakebar Amsterdam
Milkshakebar Rotterdam

I dont want the term Milkshakebar in my table.
I heard that ri can use the function mid

The tablename in the databse is Vestigingnaam.

I hope you guys can help me out, i am new to Qlikview.

Best regard

Joerie

Re: Shorten datavalues

Gysbert_Wassenaar — Tue, 28 May 2013 09:54:23 GMT

Try:

MyData:

Load

FieldA,

FieldB,

mid(Store,14) as Store,

FieldX;

Select FieldA, FieldB, Store, FieldX

From Vestigingnaam;

topic Re: Shorten datavalues in QlikView

Shorten datavalues

Re: Shorten datavalues