Field headers as row values

[Anonymous]

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-01	2017-05-02	2017-05-03	2017-05-04
500	400	350	640

but I actually want it in this format.

Date	Value
2017-05-01	500
2017-05-02	400
2017-05-03	350
2017-05-04	640

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! !

[tomasz_tru · Accepted solution]

Read this: Crosstable ‒ Qlik Sense

[arvind_patil]

HI max ,

Please use Cross Table For achieve This.

Thanks,

Arvind Patil

[Anonymous]

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]

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]

Hi Max,

look at this: https://www.youtube.com/watch?v=1xXcoi9buLM

Beck

[Anonymous]

Works great! Thank you