topic Re: Change number Format MySQL field in QlikView

Change number Format MySQL field

Anonymous — Mon, 20 Apr 2015 13:16:56 GMT

Hello everybody,

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:

123456789

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?

awhitfield — Mon, 20 Apr 2015 13:19:43 GMT

Looks like it's

Return the leftmost number of characters as specified

Andy

Anonymous — Mon, 20 Apr 2015 13:21:19 GMT

It is helpful to use preceding load, so you can use SQL functions in the SQL SELECT part and QV functions in LOAD part:

LOAD

If(Len(number)=9,Left(number,8) as Number

;

SQL SELCT

number

FROM my table;

PrashantSangle — Mon, 20 Apr 2015 13:23:25 GMT

Hi,

Qlikview have Left() but you missed closing bracket

If(Len(number)=9,Left(number,8)) as Number

Regards