- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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-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! !
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI max ,
Please use Cross Table For achieve This.
Thanks,
Arvind Patil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Works great! Thank you