Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rnc2005
Contributor II
Contributor II

Spreadsheet Structure Help

I'm helping with a proof of concept so I'm working off of a spreadsheet instead of a DB connection. 

I'm struggling with how to re-structure the spreadsheet in order to utilize Qlik. 

Screenshot 1&2) My attempt to re-structure (Fail)

Screenshot 3) The Survey

How would you recommend the sheets be structured? 

Thank you!!!

 

Screenshot_20191120-104217_Sheets.jpg

Screenshot_20191120-104326_Sheets.jpg

Screenshot_20191120-104208_Sheets.jpg

 

1 Solution

Accepted Solutions
aworrall
Luminary Alumni
Luminary Alumni

Hi. Qlik loves tall skinny data rather that short wide data. What about a list with the headings Topic, Question, Employee, Score. You can link this to your Employee data to view your data by which ever element you choose. Average scores by topic, by question. Happiest employees etc

View solution in original post

1 Reply
aworrall
Luminary Alumni
Luminary Alumni

Hi. Qlik loves tall skinny data rather that short wide data. What about a list with the headings Topic, Question, Employee, Score. You can link this to your Employee data to view your data by which ever element you choose. Average scores by topic, by question. Happiest employees etc