...ecause the header line is different from the first 2 " (txt, codepage is 28591, embedded labels, delimiter is ',', msq, header is 2 line) " vs (txt, codepage is 28591, e...
I'm trying to work with a file that comes from an industrial computer. Before I can import into my Qlik application, I need to figure out how to handle the multipleheader rows and data that u...
Hi All, The script below loads the data into qlikview file for multiple sheets in a single load by using the Loop statements. LET vStartSheetNumber = 1; LET vEndSheetNumber = 50; LET v...
...elow:
Mrkt
Loc1
Loc2
Loc3
USA
1
2
0
Headers should be static. In Pivot: Dimension as 'Mrkt' Column as 'Location' Measure as Sum(value). I tried multiple...
Hi! I have the following problem: I have to load data from multiple excel files (one file is created each period). The period field is presented in a single cell in the header of each excel file....
...here are multiple columns, the ordering gets lost and makes it hard to read. I think the look of the standard table better, but of course I need to include measures that are pivoted by year with d...
Hi everyone, I came to an issue regarding creating a treemap. I need to group the headers and sub-calculations.In the attached excel file, I have shown the raw data to the sorted data t...
Need some help with pivot table with multipleheaders. Dates will be dynamic, eg: it can also have data for Aug-2018 I tried to follow https://community.qlik.com/t5/QlikView-Documents/multi-header...
Hi,
I have an excel file with multipleheaders, kindly suggest how can i read this
File looks like above
please suggest any workaround to read this file
R...
