Discussion Board for collaboration on QlikView Scripting.
How can I transform the attached spreadsheet into a 'normal' table in QlikView please?
Go to Solution.
Something like this?
(ooxml, embedded labels, table is Sheet1, filters(
That is perfect. Where can I read more about the two functions you use in QlikView? I cannot locate them in Help. They are interesting.
Sorry for a late response. So I am not sure if there is anything about this in help, but I can tell you how I did this and how you can do other manipulation to your data within that place.:
Step1: When you on Edit Script window -> click on Table Files... (as you would usually do to bring in any Excel file)
Step2: Click next (after making any changes like Embedded Labels or Header Size or Tables) NOTE: DO NOT CLICK Finish
Step3: Click on Enable Transformation Step
Step4: Do you data manipulation as desired (I used Rotate tab to transpose your data)
I hope this will help.