Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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