topic Re: Qlikview: Line Chart With Daily Values and Month as my visible dimension in QlikView

Qlikview: Line Chart With Daily Values and Month as my visible dimension

Anonymous — Fri, 23 Feb 2018 22:28:38 GMT

I am trying to create a line chart that shows values for each day of the year, but I would like my axes to show the name description of the month. I currently have the day within the year 1-365 assigned to each calendar day and the corresponding month within my calendar table. Below you can see what I have gotten so far, but I would like to not show the 0-365 days as my dimension/label and instead on Day 1 show Jan, 32 show Feb and so on.

Another example would be I have hourly data for energy that I would like to show to see the spikes within a day, but the label would be day as I'm showing a week/month's worth of data points in the chart.

I'm not allowed to publish calculated dimensions at this time, though if it is my only option I will present and try for approval.

I'm currently working in QlikView 12 and thanks in advance for any help.

Re: Qlikview: Line Chart With Daily Values and Month as my visible dimension

Anil_Babu_Samineni — Sat, 24 Feb 2018 00:08:49 GMT

Tough to explain, will you provide sample. One reason could continuous option may solve the problem

Re: Qlikview: Line Chart With Daily Values and Month as my visible dimension

Anonymous — Mon, 26 Feb 2018 17:09:32 GMT

I'm really sorry for the delay, I'm having trouble figuring out how to attach a file. I have an excel file with sample data and chart I can upload.

Re: Qlikview: Line Chart With Daily Values and Month as my visible dimension

Anonymous — Mon, 26 Feb 2018 17:17:55 GMT

Hi Brandi,

You can attach files to Replies by clicking on "Use Advanced Editor" in the upper right corner.

Then, choose "Attach" from the lower right corner.

I hope this helps!

Best,

Qlik Community Team

Re: Qlikview: Line Chart With Daily Values and Month as my visible dimension

Anonymous — Mon, 26 Feb 2018 17:20:33 GMT

Just to clarify, you'll need to visit the actual thread in the community, rather than replying from your Inbox & Activity area of your profile. When viewing your Inbox, just click on the thread title to go to the actual thread:

Re: Qlikview: Line Chart With Daily Values and Month as my visible dimension

Anonymous — Mon, 26 Feb 2018 17:20:48 GMT

When I click reply I don't have the option of use advanced editor showing up in the right hand corner as your screen shot shows. Is there a browser or version that I need to make sure I'm on?

Re: Qlikview: Line Chart With Daily Values and Month as my visible dimension

Anonymous — Mon, 26 Feb 2018 17:24:12 GMT

Sorry for the delay, please find attached an excel file with some sample data and an example chart. I don't need the months to repeat as they are in the attached file, but if that is the best we can get we will deal with it.

Thanks again for the assistance.

Re: Qlikview: Line Chart With Daily Values and Month as my visible dimension

Anonymous — Mon, 26 Feb 2018 17:24:37 GMT

Thank you, sorry for the confusion on my part.

Re: Qlikview: Line Chart With Daily Values and Month as my visible dimension

Anonymous — Mon, 26 Feb 2018 17:25:14 GMT

Hi Brandi,

Are you viewing the thread itself, or from the Inbox area? Here's a direct link to the thread: Qlikview: Line Chart With Daily Values and Month as my visible dimension