Multiple choice data input

[#1]

Hi,

Please forgive me if this is either an inappropriate or neewb question but I am just that....the newb bit, hopefully never too inappropriate.

I have recently been provided with an excel spreadsheet that houses a series of multiple choice responses to a lengthy questionnaire. The questions all relate to a an individual user, role and region. I have spent some time sorting the responses into individual columns for each question as previously this information was held in single fields no matter of how many responses had been received, I did this as it is effective for the process of pivot tabling this info.

We are required to create a friendly viewing format over a number of sections, all of which helpfully are in different question format within qlikview, as a result I am looking to see if qlikview can cater for this. i.e would anyone know how I could import the information so that question one can provided with five different columns that hold the respective answers producing single charts and graphs? If so how is this achieved? I have provided some dummy data to help assist if the above did not help in explaining the issue.

Many thanks to anyone who can offer any words of advise.

P

Role	Country	Region	1.1a	1.1b	1.1c	1.1d
Dave	Scotland	Edignburugh	Neither	AMTP	Growth Spurt	NA
Dave smith	England	Southampton			Growth Spurt	None of the above

[stigchel]

Qlikview can cater for this, I use for example the below technique. Put Labels in as dimension and a selection in Questions or QuestionText will limit to the corresponding levels in one question.

MultiCrosstable:

crosstable(Levels,Data,1)

load ID,

if(V140_1>=0, V140_1) as [V140_1],

if(V140_2>=0, V140_2) as [V140_2],

….

From

load * inline [Questions,Levels, Labels, QuestionText

'V140','V140_1','Price','Question 140: What should we improve?',

'V140','V140_2','Product','Question 140: What should we improve?',

…

];

[neetu_singh]

hi,

Please find attached qvw file. Hope it will help you out.

Regards

Neetu