Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Field headers as row values

Hi,

I've set up a connection between Mixpanel and Qlik through the Qlik REST Connector. I've successfully managed to create the connection and autogenerated a script. This gives me the data I'm after, but in a format that is difficult to handle when trying to visualise the data.

Right now the data is in the following format

2017-05-012017-05-022017-05-032017-05-04
500400350640

but I actually want it in this format.

DateValue
2017-05-01500
2017-05-02

400

2017-05-03350
2017-05-04640

I'm new to Qlik and I have trouble understanding how I can reformat this data into the wanted format. I've attached the autogenerated Load Script and put a comment by next to the table of interest.


If you need more information I'm happy to explain my issues further.

Thank you for your time! !

1 Solution
6 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

HI max ,

Please use Cross Table For achieve This.

Thanks,

Arvind Patil

Anonymous
Not applicable
Author

Hi Tomasz,

Thank you, it works as I wanted it!

I still have one small issue. The function sees the first field header ('2017-05-01') as a qualifier field and therefore keeps it as a field header. I've tried setting the number of qualifiers to 0 but that did not work. Is there a way to move all of the field headers into rows?

Do you have any suggestions?

Thanks!

tomasz_tru
Specialist
Specialist

Not an elegant solution but it works:

CrossTable (Data, Value)

LOAD

'Dummy' AS Dummy,

*

FROM [lib://lib/file.xlsx]

(ooxml, embedded labels, table is Arkusz1); //my example file

DROP FIELD Dummy;

beck_bakytbek
Master
Master

Anonymous
Not applicable
Author

Works great! Thank you