Display records based on given expression in qliksense

[berryandcherry6]

Hi,

INVITATION:

LOAD * INLINE [

unique_id,batch_id

2334,2

3223,2

];

USERQUESTION:

LOAD * INLINE [

question_id,answer_choiced_id as answerID,unique_id, question type,user_answer

311,2,2334,multiple,

312,1,2334,multiple,

313,0,2334,freeform, I was so sick that i had surgery.

311,4,3223,multiple,

312,5,3223,multiple,

313,0,3223,freeform,i am unemployeed, lost both part time jobs

];

ANSWERTEXT:

LOAD * INLINE [

answer_id as answerID, answertext

2,short on cash

1,too late

4, stuck on bills

5, none above

7, no work

3,late payment

];

My required output

unique_id	multiple question 1	multiple question 2	freeform
2334	short on cash	too late	I was so sick that i had surgery.
3223	stuck on bills	none above	i am unemployeed, lost both part time jobs

I am using dimensions:

Dimension1 :multiple question 1 (i.e question num 311): if(match(question_id,'311'), answertext)

Dimension2 : multiple question 2 (i.e question num 312): if(match(question_id,'312'), answertext)

Dimension3 : freeform (i.e question num 313): if(match(question_id,'313'),user_answer)

But i am able to view only one question field(that question could be any question which is first put), other questions field shows null.

How could i do this in straight Table?

[kevinalvino]

Hi Supriya R

Please take a look at the apps attached.

I can only created the result through pivot table though, still no luck from normal table.

In the script i do left join for all table to USERQUESTION.

in the Pivot table, in the measure :

if(question_id <> '313',Only(answertext),Only(user_answer))

I'll try to make the straight table version * if i can

Hope it helps though,

Best Regards,

Kevin