Hi Folks I have an excel file which I want to convert using cross-table, which I'm happy to do, but the issue that is causing some problems for me is that the columnar data has three heading rows, a...
Hi QC! I am fairly new to Qlikview, and thought I knew what I was doing until I tried to input a table from Excel today. I have a complex excel table, with multiple levels of column headers (ie f...
...iles may have no of worksheets and are not limited in number and may vary from book to book -Name of every sheet in the every excel file is different -In every source excel file only the 1st sheet w...
Hi all, I have a situation where I need to import multiple files into 1 table. The files can have different column headers and some include columns others don't etc. e.g. file 1 might i...
Hi all, Can anyone share a good method for loading multiple tables from the same excel tab into QV? Each table has a similar structure except the amount of rows can vary (between 9 and 15) and t...
Hello, I'm loading multipleexcel files which have a relatively consistent structure. Additional files are generated in the source location regularly. The application which g...
...table that looks like the table in the attached Excel file. I have tried a straight table and a pivot table, but cannot seem to figure out how to get all the main column headers (State, User, C...
Hi Experts, I have a source excel file : Required format : I want to load this source file into Qlikview as : I am trying to do this using Crosstable but no s...
Hello all, I need your help to solve my issue. I have a excel file with a multipleheader row like this : so what i would doing is : when i went to loaded this excel file, and add may be some s...
Hi folks, I'm trying to load an excel file in Qlikview which has Customer Name in Row Headers, each file can have multiple number of customers and each customer can have any number of records. I...
