Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RogerG
Creator
Creator

Survey Results per function per question

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

Labels (3)
0 Replies