topic Re: MID() to Month with error in QlikView

MID() to Month with error

vinisefrin — Mon, 09 Sep 2013 16:30:32 GMT

Good afternoon, I need to solve the following question:

I got a script here, and the people doing the following ...

MID (Data_Referencia, 4.2) as Month_Select

where the reference date in this format 01/08/2013.

thus returning this:

But if I send in the property list display as number with four decimal places of precision, shows me correct:

therefore, can not make a key with a Load * inline to bring the "name" of the month, which could be easily solving through a month ().

But do not want to mess around scritp, they may compromise the rest of the application ...

These two ways he does not let you make your selection in the "names" because of the records they see everything as 01.

Know cuz it occur?

Hugs and Thanks

Re: MID() to Month with error

Clever_Anjos — Mon, 09 Sep 2013 16:33:01 GMT

If you want the month number, you should use Month() function, no Mid.

Month() will handle formating dates issues

Re: MID() to Month with error

vinisefrin — Mon, 09 Sep 2013 16:52:15 GMT

Clever Good afternoon,

Yes, I am aware that the correct use would be the month (), but the script is not mine, I can not change, just wanted to understand why he was returning the records in this way, 01 and not the correct month, and formatting with 4 decimal places of accuracy in the properties of the list it shows correct.

hugs