Loading and Displaying Entire Excel file in Qlikview Table
I have an excel file with nearly 45 Column. If I use Control +E (Script Edit) and Select Table Files, I can load the Excel into Memory. But to Display entire Excel file in Straight Table, I have to manually create 45 expressions.
Is there any simple method to display entire excel file in straight table ?
I didn't get your question, Why not simply load whole excel into Qlikview and then create object with your all dim's then you will get every data of each Dim.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
If you just want to display that 45 columns in a table. you better take that fields into table box instead of Straight table. or else you can add all fields as dimensions in straight table.
Thanks. Initially I was using a Add Chart-> Standard Table-> Trying to add one by one all field. It was tedious task. Then I found we can add solution as per the link I shared above -> Layout->Newsheet-> Add Table Box. Which solved.
