topic Rotate table in Qliksense in App Development

Rotate table in Qliksense

Aspiring_Developer — Tue, 22 Aug 2023 14:49:43 GMT

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

Re: Rotate table in Qliksense

Oleg_Troyansky — Tue, 22 Aug 2023 15:18:36 GMT

Hi,

It looks like you need a simple Pivot Table.

Dimensions: User ID, User Number

Columns: Question

Measure: only(Feedback)

Cheers,

Re: Rotate table in Qliksense

Aspiring_Developer — Tue, 22 Aug 2023 16:58:02 GMT

Hi @Oleg_Troyansky

Thanks for your input . But I have to do it backend . Could you please help me with it ?

Thanks again

Re: Rotate table in Qliksense

Oleg_Troyansky — Tue, 22 Aug 2023 17:23:19 GMT

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,