topic Format problem in QlikView

Format problem

Tue, 01 Jun 2010 16:41:44 GMT

Hi all !

I'm sure that it will be not easy for you to understand, but I need to ask it...

My data is loaded from an SQL server database. A field name "newvalue" has a varchar(max) data type. We use it to put what we want... Date, text, number... But we don't want to analyse it... So it will be store into this varchar(max) data type.

In my QVW script, I load data directly and store it into a qvd.

BUT ! We have some strange result. When we display this field "newvalue" :

- SQL Server : 51200.0000
- QVW field : 05/03/2040

We don't know why QVW transform it whit a date format. In QV, the format was not overridding.

The most strange is that we have many over data in SQL Server like "51200.0000". But only this value is "data formated"...

--------------------

In a second time... I load only the line with 51200.0000. And it's a miracle ! QVW display 51200.0000. I store it and reload from a QVD... always 51200.0000.

So my question is : WHY ? why QV transform a text field with 51200.0000 into 05/03/2040 !?

Many thanks all. I'm realy sorry, but I can't be able to give you an application.

Christophe

Format problem

Tue, 01 Jun 2010 17:47:17 GMT

Go to Document Properties -> Sheet Number -> Select your field -> and select the number format Number, Integer or Fixed to

Best regards,

Re:Format problem

Mon, 14 Jun 2010 08:59:17 GMT

Ok... I understand this, but it's not my purpose. What I want to know is not how to format something I d'ont want to format.

In my field I cou ld have text, number, date or something else... I just want to display without any conversation.

Here, if I have '51600.0000', I wan't to display '51600.0000'

If I have '01/01/2010', I wan't to display '01/01/2010'

But in my example, a value who originaly contains '52000.0000' in mysql server database is displayed '05/03/2040' that i've never asking for !

Format problem

dirk_konings — Mon, 14 Jun 2010 10:00:55 GMT

just load it with text(newvalue) as newvalue.

Format problem

Wed, 23 Jun 2010 22:20:28 GMT

What I think is happening is that your first record that is loading has a date in that field. I ran into this same type of issue when loading excel spreadsheets into MS Access. What I do is re sort the spreadsheet so that text is first, then MS Access puts that field as text, not a number.

I wondering if this is happening to you.