Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All ,
I have below data set :-
UserID | UserNumber | Feedback YN | Question |
29 | 11111111 | YES | Q1) Did you completed the day one activities ? |
30 | 11111111 | YES | Q2)Did you share the infomration with customer ? |
31 | 11111111 | N/A | Q3) Did you escalate if required ? |
32 | 11111111 | YES | Q4Did you follow the closure process ? |
I wish to achieve the below output :-
UserID | User Number | Q1) Did you completed the day one activities ? | Q2)Did you share the information with customer ? | Q3) Did you escalate if required ? | Q4) Did you follow the closure process ? |
29 | 11111111 | YES | |||
30 | 11111111 | YES | |||
31 | N/A | ||||
32 | Yes |
I tried this solution but couldn't implement it properly . Solution URL -Solved: Rotate table - Qlik Community - 1683696
Can anyone please help ? @Taoufiq_Zarra
Thanks
Hi,
It looks like you need a simple Pivot Table.
Dimensions: User ID, User Number
Columns: Question
Measure: only(Feedback)
Cheers,
Hi,
It looks like you need a simple Pivot Table.
Dimensions: User ID, User Number
Columns: Question
Measure: only(Feedback)
Cheers,
Thanks for your input . But I have to do it backend . Could you please help me with it ?
Thanks again
Hmm, it's a lot more difficult to achieve in the back end. I'll give you a couple of ideas that you'll need to explore on your own:
1. Look into the GENERIC load feature, maybe you can use it to build a script that can rotate your table.
2. In QlikView, there is a table file load Wizard that contains the ability to Rotate the whole table. It might work for you. If it does, then you can copy the generated script, replace the Data connection in it, and use it in Qlik Sense. The same functionality works, but there is no UI that would allow you to generate that script in Qlik Sense.
Cheers,