topic Re: data not showing in QlikView table from uploaded excel data in QlikView

data not showing in QlikView table from uploaded excel data

Anonymous — Sat, 19 Sep 2015 05:18:27 GMT

Hi.

I am loading data from excel and the load into QlikView loads with no errors BUT then when I check the table the values are all zero. I did check that the data is there on the actual load but still nothing is showing. I made sure the figures were formatted to numbers in excel also. Any hints as to what to check?

Any help appreciated.

Re: data not showing in QlikView table from uploaded excel data

robert_mika — Sat, 19 Sep 2015 05:43:31 GMT

Could you post screenshot, data, or your app?

Re: data not showing in QlikView table from uploaded excel data

Anonymous — Sat, 19 Sep 2015 05:56:38 GMT

Re: data not showing in QlikView table from uploaded excel data

Anonymous — Sat, 19 Sep 2015 05:57:29 GMT

can you see excel attachment?

Re: data not showing in QlikView table from uploaded excel data

ecolomer — Sat, 19 Sep 2015 05:59:11 GMT

check that it is accessing the correct excel sheet.

If you use the wizard to access the QV excel file, you see the data in the pantallacorrectamente?

Can you make a screenshot of the identification of the data?

Re: data not showing in QlikView table from uploaded excel data

PrashantSangle — Sat, 19 Sep 2015 06:03:06 GMT

Hi,

When I load data from xls file. I am able to see all data.

what issue you are facing??

I am using below script to load data.

data:

LOAD Team,

team_id,

role,

id,

Consultant,

July,

Aug,

[1/09/2015],

[1/10/2015],

[1/11/2015],

[1/12/2015],

[1/01/2016],

[1/02/2016],

[1/03/2016],

[1/04/2016],

[1/05/2016],

[1/06/2016]

FROM

[..\Desktop\Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards,

Re: data not showing in QlikView table from uploaded excel data

ecolomer — Sat, 19 Sep 2015 06:03:12 GMT

see this

Re: data not showing in QlikView table from uploaded excel data

Anonymous — Sat, 19 Sep 2015 06:05:40 GMT

Hi Enrique, yes I checked to see the data when loading it:-

Re: data not showing in QlikView table from uploaded excel data

Anonymous — Sat, 19 Sep 2015 06:14:55 GMT

should I be using a temp table to load the data first?

Re: data not showing in QlikView table from uploaded excel data

Anonymous — Sat, 19 Sep 2015 06:18:18 GMT

this is the script I'm using.:-

Concatenate(Facts)

LOAD Team,

team_id,

role,

id,

Consultant,

July,

Aug,

[1/09/2015],

[1/10/2015],

[1/11/2015],

[1/12/2015],

[1/01/2016],

[1/02/2016],

[1/03/2016],

[1/04/2016],

[1/05/2016],

[1/06/2016]

FROM

[..\Desktop\Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: data not showing in QlikView table from uploaded excel data

ecolomer — Sat, 19 Sep 2015 11:46:34 GMT

In Header Size you need put Icluded header

Re: data not showing in QlikView table from uploaded excel data

ecolomer — Sat, 19 Sep 2015 11:47:17 GMT

Yo can see my file QV

Re: data not showing in QlikView table from uploaded excel data

Anonymous — Sun, 20 Sep 2015 04:34:35 GMT

thank-you

Re: data not showing in QlikView table from uploaded excel data

ecolomer — Sun, 20 Sep 2015 05:50:14 GMT

you're welcome

Re: data not showing in QlikView table from uploaded excel data

Anonymous — Thu, 24 Sep 2015 08:15:02 GMT

Hi again,

I thought my date issue was resolved but it's come back to haunt me. Can you please help me?

I have attached it all to explain.