Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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.
Thank you this worked.