Plotting Time Data with Dates in Multiple Columns

[Anonymous]

Hello,

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

Account | Various Categories | Month1 | Month2 | Month 3 | ...

  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

[marcus_sommer · Accepted solution]

You could easily transform your data per The Crosstable Load.

- Marcus

[Anonymous]

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