Challenge in Data Load - Need help

Wed, 22 Dec 2010 07:47:28 GMT

Dear All,

Please find the enclosed sample files
I have set of 8 Questions (in old sample file) for which AnswerId were
1 Yes
2 No
3 No feedback

Everything was fine I was fetch the questions based on the following in my script while loading
if(Num([Question No])>0 and Num([Question No])<10,'Q'&[Question No],'') as Question_No
All calculations was based on Question_No field.

But in the enclosed updated sample file, user added one new question after QuestionNo 4.
which act as sub questions for Q4. i.e 5,6,7,8
Now the Question No. sequence is changed as compare to old sample file.

Still there are basically only total 8 questions in both files, only updated file is having the new subquestions of Q4, where sequence as compared to old is changed.

The requirement is:

If the answer for Q4 (in updated sample file ) is "NO" then only Subquestions Q-5,6,7,8 comes into picture.
Again subquestion Q-5 can have Answer as Interior/Exterior

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

If subquestion Q-5 Answer is "Interior" then subquestion Q6 AnswerID need to be consider which is comma seperated, as mentioned in breakup sheet of updated sample file

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 subquestion Q-5 Answer is "Exterior" then subquestion Q7 AnswerID need to be consider which is comma seperated,as mentioned in breakup sheet of updated sample file

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

If subquestion Q-5 Answer is "Interior,Exterior" then both subquestion Q6,Q7 AnswerID need to be track

Note:
Need to maintain the QuestionNo sequence number same as given in old sample file.
As there is huge data available in olderfile for consideration.

Please suggest how to load the data so that we can maintain and track the above records with compare to old sample file and generate graph as given in "breakup" sheet of "Updated sample" file.

Thanks,
Kumar

Challenge in Data Load - Need help

sunil2288 — Wed, 22 Dec 2010 08:06:44 GMT

Hi Kumar,

How are u..

You can use inline function to map the newer updation along with the previous data.

Thanks and Regards

Sunil

Challenge in Data Load - Need help

suniljain — Wed, 22 Dec 2010 08:12:02 GMT

you can also maintain answer id data in excel and used it in your QV application.

Challenge in Data Load - Need help

Wed, 22 Dec 2010 08:14:16 GMT

Hi Sunil,

I am fine, Hope u are doing fine.
Can u express in detail providing one sample?

Thanks,
Kumar

Challenge in Data Load - Need help

sunil2288 — Wed, 22 Dec 2010 08:29:29 GMT

Hi Kumar,

Actually i am not able to open the sample file u have attached.

But i can suggest you to take a look to the older sample and try to map the newer field as concern.

Thanks And Regards

Sunil

topic Challenge in Data Load - Need help in QlikView

Challenge in Data Load - Need help

Challenge in Data Load - Need help

Challenge in Data Load - Need help

Challenge in Data Load - Need help

Challenge in Data Load - Need help