Line Chart with Missing Date Values

triekong — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i am trying to create a line chart, but my dataset does not contain a singular date field. Instead, it contains multiple fields of the dates, and I'm having a hard time figuring out how to build it into a line chart. the line chart should go by months and should sum up the total for each of the months.

Do i need to use a Master Calendar? and if so what field would i put as Date?

this is my data table

Elements	January	February	March	April	May	June	July	August	September	October
Iron	4	5	6	6	7	7.7	8.4	9.1	9.8	10.5
Metal	7	1	0	4	8	11	15	18	22	25
Fiber	4	7	5	6	7	7	8	8	9	9
Sulphur	3	5	2	2	2	1	1	0	0	1

i have attached a sample file

Please suggest a workaround or a possible solution!

thanks!

Re: Line Chart with Missing Date Values

Frank_Hartmann — Wed, 14 Mar 2018 20:37:49 GMT

You will need to use Crosstable Load in script. You can use a MasterCalendar but you dont need to.

But it makes things often much easier 🙂

see attached file.

hope this helps

Re: Line Chart with Missing Date Values

sasiparupudi1 — Thu, 15 Mar 2018 09:00:49 GMT

Use Crosstable

topic Re: Line Chart with Missing Date Values in QlikView

Line Chart with Missing Date Values

Re: Line Chart with Missing Date Values

Re: Line Chart with Missing Date Values