Date field not recognized in Analysis to make bar chart

[RainF]

Hello,

I am trying to make a chart visualization to show sums for each month. In the data I have loaded, the header fields show as 01/01/2021, 02/01/2022, etc. But when I go to make a chart, Qlik does not recognize the header dates. Below is a sample of the data loaded into Qlik. And below that is an Example of what I would like the chart to look like. 

Any Tips? 

1/1/2021	2/1/2021	3/1/2021
1778	1605	1637
199	127	76
2227	1702	1587
256	166	129
1718	1120	1112

[Lisa_P · Accepted solution]

The problem is the structure of the table where the headers/field names you want to use as dimension values. In the load script, you can use the crosstable prefix to convert/unpivot this data to the format you need.

[RainF]

Thank you this worked.