Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
lauracastagna
Creator II
Creator II

data not showing in QlikView table from uploaded excel data

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.

1 Solution

Accepted Solutions
ecolomer
Master II
Master II

14 Replies
robert_mika
Master III
Master III

Could you post screenshot, data, or your app?

lauracastagna
Creator II
Creator II
Author

!

lauracastagna
Creator II
Creator II
Author

can you see excel attachment?

ecolomer
Master II
Master II

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

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.
ecolomer
Master II
Master II

see thisp51.png

lauracastagna
Creator II
Creator II
Author

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

lauracastagna
Creator II
Creator II
Author

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

lauracastagna
Creator II
Creator II
Author

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);