Survey Results per function per question

RogerG — Sun, 22 May 2022 00:08:54 GMT

Hello all, I am looking for guidance here.

I have a data set that contains a function, questions and answers. not all questions have the same set of responses, so that trellis doesn't help me

I am trying to answer questions with the below sample set such as

1 - How many people who are new to using the tool would recommend it to a friend

2 - how many people who used the previous tool are from which function.

I was trying to create a chart with Function and Answer as a dimension, then put the answers and percentage of the response to the answer on a barchart

It would be one chart per question / answer set

I did a cross table to get the question/answer data table

DataLoad: CrossTable(Question, Answer) LOAD Function, [How long have you worked in Tool?], [The purpose of Tool is clear], [How likely is it that you would recommend Tool to a friend or colleague?]

I also have inline tables which define valid answers to questions

Gemeric: LOAD * INLINE [ ResultSortOrder,AnswerGeneric,RD,GN,BL 1,Strongly Agree,33,102,172 2,Agree,103,169,207 3,Neutral,254,224,144 4,Disagree,239,138,98 5,Strongly Disagree,178,26,43 ]; duration: LOAD * INLINE [ PreviousSortOrder,AnswerPreviousSolution,REDs,GRN,BLU 1,Strongly Agree,33,102,172 2,0-6months,103,169,207 3,6months to 1year,254,224,144 4,longer than one year,253,219,199 ];

I just cannot determine the proper set analysis to get the first chart to just show the duration.

I end up with all possible answers. I am working on one chart per question as an end goal.

thanks in advance

topic Survey Results per function per question in QlikView

Survey Results per function per question