This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
We need to read a formatted report with groups. We need the group header on each row of the detail
Would we previous, peek or something else?
Peek and Previous are quite powerful. Below is my solution
FOR EACH vFile IN FILELIST('<somefolder>\*.xlsx')
LET vMonth = MID(vFile,28,2);
$(vDate) AS [Report Date],
rowno() AS [Report Row],
recno() AS [Report Record],
IF(A='Service Type',PREVIOUS(A),PEEK('Section Header')) AS [Section Header],
$(vFile) (ooxml, no labels, table is Sheet1)
NOT (A='Service Type' OR ISNULL(A)) !
DROP TABLE TEMP_DATA;
View solution in original post
Try this script, I generated it through transformations steps while loading excel file.
LOAD [Header 1],
(ooxml, embedded labels, table is Sheet1, filters(
Replace(1, top, StrCnd(null)),
Remove(Row, RowCnd(CellValue, 2, StrCnd(null)))
Excel sample attached here.
check this out in case you are not using any external file and loading the data using resident loads.
you can use both peek and previous, in the qvw attached i've used peek function though.
Sorry about that - I didn't get a chance to read through your script before resolving this on my own.