Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am pulling in a number of spreadsheets from Excel and there are values in hidden rows that I need to ignore. As there are a large number of locked workbooks it will take a long time to modify the spreadsheets to mark the visible rows.
Is there a way in the load script to simply skip over rows that have been hidden?
- Dan
Hidden lines are not "marked" to QlikView to identify them. It´s not an atribute from the data, but from the visualization in excel. So, im afraid you´ll have to mark all those sheets...
Regards
Fernando
Hidden lines are not "marked" to QlikView to identify them. It´s not an atribute from the data, but from the visualization in excel. So, im afraid you´ll have to mark all those sheets...
Regards
Fernando
Fernando - thanks for you reply. We were able to find an alternative list within the spreadsheet in the end fortunately. But I know now for next time!
I'm glad I could help!
Best regards,
Fernando