Solved: Re: data not showing in QlikView table from upload... - Qlik Community

Anonymous · ‎2015-09-19

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.

ecolomer · ‎2015-09-20

you're welcome

View solution in original post

robert_mika · ‎2015-09-19

Could you post screenshot, data, or your app?

Anonymous · ‎2015-09-19

!

Anonymous · ‎2015-09-19

can you see excel attachment?

ecolomer · ‎2015-09-19

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?

PrashantSangle · ‎2015-09-19

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ecolomer · ‎2015-09-19

see this

Anonymous · ‎2015-09-19

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

Anonymous · ‎2015-09-19

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

Anonymous · ‎2015-09-19

this is the script I'm using.:-

Concatenate(Facts)