I have a similar problem, with data stored in separate Excel files.
Questions and response options are along the lines shown below
Question: Where do you think pollution levels will be in 1 year for the following regions: a) Europe, b) US, c) SE Asia, d) LATAM ?
i) Significantly higher
ii) Moderately higher
iii) About the same
iv) Moderately lower
v) Significantly lower
If anyone has any experience using QlikView to visualise series of survey questions as above, with historical look back, I would be very greatful for any insight.