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.
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.
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.