Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
triekong
Contributor

Line Chart with Missing Date Values

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

   

ElementsJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctober
Iron456677.78.49.19.810.5
Metal710481115182225
Fiber4756778899
Sulphur3522211001

i have attached a sample file

Please suggest a workaround or a possible solution!

thanks!

2 Replies
Frank_Hartmann
Honored Contributor II

Re: Line Chart with Missing Date Values

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

sasiparupudi1
Honored Contributor III

Re: Line Chart with Missing Date Values

Use Crosstable