Discussion board where members can get started with Qlik Sense.
LOAD * INLINE [
question_id,answer_choiced_id as answerID,unique_id, question type,user_answer
313,0,2334,freeform, I was so sick that i had surgery.
313,0,3223,freeform,i am unemployeed, lost both part time jobs
answer_id as answerID, answertext
2,short on cash
4, stuck on bills
5, none above
7, no work
My required output
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?
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,