Problem with a crosstable

[#1]

Hello everybody

Today Ihave a problem with a crosstable. I want to load a Excel table to QlikView. This table have 3 Qualifier Field. In the Attribute Filed I have the date and data.

In the result window of the wizard the finished table is displayed ok. If I loading the script the result is that I will become also the date for the data field.

What is the problem. Why QV dont load the data like the Result of the wizard?

Please help. Thanks

greetings Sven

[parthiband]

Hi Sven,

Can u please attach the sample qvw with excel

Thanks

[#3]

Hi Parthiban.

Yes I will attach a sample. The sample is ok and works right.

the principle is the same like in the orginal. The difference is that one more lines bettween the data in the orginal.

I have one more question. Why cannt I change the format of the date?

Please look at the sample.

[parthiband]

Actuallu the first rename the field Date with any other name, lik, ORD_DATE

In QV if the data aligned on the LEFT means its a TEXT and if its aligned right means its an formated one.

Formated one in the sense, either its an number or an date..

Now u would be clear its an unformatted one..

Use Date#() to explictly change it to Date

Thanks

[Gysbert_Wassenaar]

See here.

[#6]

Ok the problem with the date is clear.

ButI still I have the problem that the data is output as a date. I think it is the same problem like the date.

The data in the Excel spreadsheet with commas, like 52,23 etc..

What can I do?

[parthiband]

Yeah svenarnold, what Gysbert Wassenaar told was right..

u should use this to convert that

Date(Num#(Date))

I guess u would've changed now

Thanks

[#8]

The case is closed.  I need the Excel Sheet of my sample. In this sample the format of data is ok and the data is output in QV allright. I think it is a Problem of the format of Excel.

Thanks for your help.

Greetings Sven