Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

Tags (1)
6 Replies

Re: Recreate a Spreadsheet within QlikView

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

Not applicable

Re: Recreate a Spreadsheet within QlikView

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
Valued Contributor III

Re: Recreate a Spreadsheet within QlikView

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

Re: Recreate a Spreadsheet within QlikView

‌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

Re: Recreate a Spreadsheet within QlikView

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
Valued Contributor

Re: Recreate a Spreadsheet within QlikView

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.

Community Browser