Difficulty in Data Load - Help!!

Wed, 29 Dec 2010 08:31:09 GMT

Hello,

Please go through the requirement and suggest how can this requirement can be achieved.
Thanks in advance as this would be great help for me.

Requirement
============

I have total 6 Questions to be answered by customer in Yes/No.

Now I have few sub-questions as mentioned below for Q4 to be asked when customer says "No"
Following sub-questions to be asked when customer says "No" as Answer for Q4

*If vehicle not delivered clean (If Question 4 response is No)Area of concern
*If Washing Concern is Interior Cleaning""
*If Washing Cocern is Exterior Cleaning""
*Overall Rating for Vehicle Cleanliness""

Now the new questionaires having 10 questions (6+4)which look like:

Q1. Were all requested jobs done first time?
Q2. Was service completed within promised delivery time?
Q3. Was time taken for service reasonable?
Q4. Was your vehicle delivered clean?
Q5. If vehicle not delivered clean (If Question 4 response is No)Area of concern
Q6. If Washing Concern is Interior Cleaning""
Q7. If Washing Cocern is Exterior Cleaning""
Q8. Overall Rating for Vehicle Cleanliness""
Q9. Did SA explain all the jobs carried out?
Q10. Do you have any other feedback?

When customer says "No" to Q4 i.e.(Was your vehicle delivered clean?)
He has to specify the Area of concern
Answer for Question Q5 "If vehicle not delivered clean (If Question 4 response is No)Area of concern" would
*Interior
*Exterior
*Interior,Exterior

Answer AnswerID
======= ===========
Interior 1
Exterior 2
Interior,Exterior 1 ,2

If Area of concern is *Interior i.e. For Question Q6 (If Washing Concern is *Interior Cleaning"")
customer has to specify the answer out of 10 following options

AnswerID If Washing Concern is Interior Cleaning""
======== ===========================================
1 Dash Board/AC Vents/Glove Box
2 Combimeter/IRVM/Ashtray/Sunvisors
3 Steering Wheel/Switches (Wiper/H Light)
4 Gear Lever Knob/Center Console/Stereo
5 Door Trims/Cupholders/Scuff Plates
6 Seats/Seat Belts/Buckles
7 Foot Mats/Floor Carpet
8 Roof Lining/Support Handle
9 Interior vacuuming
10 Not Answered

If Area of concern is *Exterior i.e. For Question Q7 (If Washing Cocern is Exterior Cleaning"")
customer has to specify the answer out of 10 following options

AnswerID If Washing Cocern is Exterior Cleaning""
======== ===========================================
1 Windshield (FR/RR) / Window/Quarter Glass / Mirrors
2 Lamps (Head / Fog / Tail)
3 Engine Hood Panel/Front Grill
4 Roof Panel
5 Body Panel (Fender / Quarter/Rocker Panels)
6 Door Panels (Front / Rear / Dicky)
7 Bumper (Front / Rear)
8 Tyres/ Wheel Caps/Wheel Housings
9 Underbody/Engine Room/Boot Space
10 Not Answered

Here I have to use both old questionaires as well as new questionaires for analysis.
Also I have to maintain the old Questionaires QuestionNo sequence.

I am maintaining old questionaires question no sequence by adding

Q1. Were all requested jobs done first time?
Q2. Was service completed within promised delivery time?
Q3. Was time taken for service reasonable?
Q4. Was your vehicle delivered clean?
Q4A. If vehicle not delivered clean (If Question 4 response is No)Area of concern
Q4A1. If Washing Concern is Interior Cleaning""
Q4A2. If Washing Cocern is Exterior Cleaning""
Q4A3. Overall Rating for Vehicle Cleanliness""
Q5. Did SA explain all the jobs carried out?
Q6. Do you have any other feedback?"

Now how do I load the data so that
I can derive the following Graphs as attached in breakup sheet of "new questionare"

topic Difficulty in Data Load - Help!! in QlikView

Difficulty in Data Load - Help!!