I hope someone can help me. I got eight different accessfiles with data. I would like to create a linktable with all the data (date, age, sex, questions regarding information, quality and so on) except ID since they are numbered 1, 2, 3... and so on in all the eight files.
I got some other data in the same qlikviewfile so when I have tried concatenate the information from these eight files have been added to a table with data from an excelfile...
I have attached the code I have at the moment and a picture.
But for another source there are more questions regarding "Kvalité" so instead of dividing every expression with the number of questions, can I make an expression where I can ad question 1...question X and the average of those?