topic Re: excel text problem in QlikView

excel text problem

Mon, 12 Mar 2012 12:23:43 GMT

Hi ,

i have a excel file and i want to add it to qlikview file. but in one column we have both text and number .

in the qv file shows only numbers and put '-' for text rows.

How can i show all rows text and numbers together?

excel text problem

Wed, 14 Mar 2012 05:44:46 GMT

does anybody know this?

excel text problem

CELAMBARASAN — Wed, 14 Mar 2012 05:58:25 GMT

Hi,

Have you used the text function while adding in to the Qlikview.

Load

field1,

Text(Field2) as Field2,

......From datasource;

Celambarasan

Re: excel text problem

Wed, 14 Mar 2012 06:32:37 GMT

Hi,

One column includes both text and number in the rows, only numbers shown

Re: excel text problem

jagan — Wed, 14 Mar 2012 06:39:50 GMT

Hi,

Can you attach that file.

Regards,

Jagan.

excel text problem

Wed, 14 Mar 2012 06:44:33 GMT

i attached.

tahnk you

Re: excel text problem

jagan — Wed, 14 Mar 2012 06:58:01 GMT

Hi,

Please check the attachment, I didn't have any issue. Try loading data once again.

Regards,

Jagan.

Re: excel text problem

CELAMBARASAN — Wed, 14 Mar 2012 07:12:27 GMT

Hi,

Check your number format in the table?if it is expression default then check the below option

Check the default number format in Document properties-->Number tab-->Select the field-->Select the mixed option.

Celambarasan

Re: excel text problem

Wed, 14 Mar 2012 07:59:08 GMT

Hi Mixed is disable, can you send me the as qv file?

Re: excel text problem

Thu, 15 Mar 2012 09:36:17 GMT

Hi can anybody add my excel to qlikview and send me?

It is urgent pls

Re: excel text problem

CELAMBARASAN — Thu, 15 Mar 2012 09:57:30 GMT

Hi,

Check the attached

Celambarasan

Re: excel text problem

Thu, 15 Mar 2012 11:14:13 GMT

Hi Thank you very much, I will check the document asap