topic Re: Problem with a crosstable in QlikView

Problem with a crosstable

Thu, 18 Jul 2013 05:01:12 GMT

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

Re: Problem with a crosstable

parthiband — Thu, 18 Jul 2013 05:17:42 GMT

Hi Sven,

Can u please attach the sample qvw with excel

Thanks

Re: Problem with a crosstable

Thu, 18 Jul 2013 05:31:05 GMT

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.

Re: Problem with a crosstable

parthiband — Thu, 18 Jul 2013 05:50:22 GMT

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

Re: Problem with a crosstable

Gysbert_Wassenaar — Thu, 18 Jul 2013 05:52:44 GMT

See here.

Re: Problem with a crosstable

Thu, 18 Jul 2013 06:22:24 GMT

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?

Re: Problem with a crosstable

parthiband — Thu, 18 Jul 2013 06:23:28 GMT

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

Re: Problem with a crosstable

Thu, 18 Jul 2013 08:44:10 GMT

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