Plotting Time Data with Dates in Multiple Columns

Anonymous — Fri, 09 Dec 2016 17:23:37 GMT

Hello,

I am trying to plot a series of values over time in Qlik Sense Desktop. My data is arranged as follows:

1243 xxx 0% 2% 5% ...

432 xxx 5% 3% 10% ...

and so on.

What I would like is to have a separate line for each account over each month, so that the x-axis would be something like "Month 1, Month 2, Month 3, ..."

In Excel this is no issue at all, but I am not sure how to accomplish this in Qlik, or if I need to rearrange my data.

For clarity, I have 53 of these month fields, and over 58,000 accounts. I had considered transposing the data, but as it's stored in Excel I well pass the column limit of 16,384 columns.

Thank you,

John

Re: Plotting Time Data with Dates in Multiple Columns

marcus_sommer — Fri, 09 Dec 2016 18:20:38 GMT

You could easily transform your data per The Crosstable Load.

- Marcus

Re: Plotting Time Data with Dates in Multiple Columns

Anonymous — Fri, 09 Dec 2016 19:08:50 GMT

Thank you, Marcus. This was a simple fix that was incredibly helpful for me.

topic Re: Plotting Time Data with Dates in Multiple Columns in App Development

Plotting Time Data with Dates in Multiple Columns

Re: Plotting Time Data with Dates in Multiple Columns

Re: Plotting Time Data with Dates in Multiple Columns