Discussion Board for collaboration on QlikView Scripting.
I am just starting the qlikview connection with a MySql DataBase and I've encountered my first problem which is giving me a hard time.
This is my problem:
I have this sequence of numbers:
but I just need the first 8 numbers.
As a qlikview script I used the following sentence:
If(Len(number)=9,Left(number,8) as Number
but with the MySql script I can't find a similar function.
Can anybody help me?
Go to Solution.
It is helpful to use preceding load, so you can use SQL functions in the SQL SELECT part and QV functions in LOAD part:
FROM my table;
Looks like it's
Return the leftmost number of characters as specified
Qlikview have Left() but you missed closing bracket
If(Len(number)=9,Left(number,8)) as Number