Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Display records based on given expression in qliksense

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_idmultiple question 1multiple question 2freeform
2334short on cashtoo lateI was so sick that i had surgery.
3223stuck on billsnone abovei 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?

1 Reply
kevinalvino
Contributor

Re: Display questions field one after other in qliksense

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.test.png

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

Community Browser