Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Problem with a crosstable

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.

Qualifier Field.JPG

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.date_data.JPG

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

Please help. Thanks

greetings Sven

7 Replies
Highlighted
parthiband
Contributor

Re: Problem with a crosstable

Hi Sven,

Can u please attach the sample qvw with excel

Thanks

Not applicable

Re: Problem with a crosstable

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
Contributor

Re: Problem with a crosstable

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

See here.


talk is cheap, supply exceeds demand
Not applicable

Re: Problem with a crosstable

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
Contributor

Re: Problem with a crosstable

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

Not applicable

Re: Problem with a crosstable

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

Community Browser