Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Recreate a Spreadsheet within QlikView

This is probably a really basic question - if I load an Excel Spreadsheet into QlikView, is there a way to use the Table Object or a Straight Table Chart to replicate the spreadsheet? Basically just like having the spreadsheet in QlikView?

This seems like it should be easy but the Table Chart just acts like one big list box and the Straight table needs a calculation to display data.

6 Replies
MK_QSL
MVP
MVP

You can use Straight Table, Pivot Table... But simply use TableBox to create the same Excel file...

Not applicable
Author

When I try to just use the table box it returns a lot of duplicate values and ends up creating 3x the number of rows that it should. It basically groups results rather than showing each row as it was in the original excel file.

sudeepkm
Specialist III
Specialist III

if you have 100 records in your spread sheet and you load that table into QlikView then in the table box it will show you 100 records. if you are getting 3 times the records in xls file then I suspect you may have a Cartesian product created.

you may be trying to load another field into your table box which is not associated to any fields present in the table sourced from xls file. Could you please post a sample if possible.

Not applicable
Author

‌the easiest way would be place all of the fields in a table box- this is easier than building a straight table since ypi do not need to create any expression

Not applicable
Author

Right, my issue is that the Table box does not seem to like blank values and somehow blank values in my spreadsheet mess up the Table Box and have it count things twice

evan_kurowski
Specialist
Specialist

Hello Tim,

I agree with comments that it should not be possible to have a Table box create additional rows beyond the source material if you are only working with a single table.

Extra rows are possible when you combine fields from multiple tables.

A good way to get a "handle" on your Excel data is to assign it a record id field, something like:

RecNo() AS EXCEL_ROW_ID

As long as your Excel spreadsheet does not contain fully null rows, you should find the same EXCEL_ROW_ID in QlikView lining up exactly with that Row # in the Excel spreadsheet.