Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
MyData:
Load
FieldA,
FieldB,
mid(Store,14) as Store,
FieldX;
Select FieldA, FieldB, Store, FieldX
From Vestigingnaam;