topic Re: Show Daily-Data in Monthly Dimension in a Chart in QlikView

Show Daily-Data in Monthly Dimension in a Chart

Thu, 08 Sep 2016 15:54:14 GMT

Hello Q-Community

is there any solution to show daily-data in a monthly-dimension?

I want to show the blue line like this:

Thanks a lot.

Re: Show Daily-Data in Monthly Dimension in a Chart

sunny_talwar — Thu, 08 Sep 2016 19:27:45 GMT

May be you need this: Formatting on continuous Axis | Qlik Community

Re: Show Daily-Data in Monthly Dimension in a Chart

Fri, 09 Sep 2016 07:16:14 GMT

Hi Sunny

thanks for your quick response.

May be i have been unclear.

My problem is, that i have a chart with year-month as dimension. In this way I loose the daily granularity of the blue line (see first picture).

My purpose is to show the blue line with daily granularity in the first chart, which has year-month as dimension.

Thanks

Re: Show Daily-Data in Monthly Dimension in a Chart

Anonymous — Fri, 09 Sep 2016 07:35:52 GMT

Any sample data?

To achieve your desired output, your dimension on x-axis should have more value like 20+ ate one time...

Same you can't achieve with 5-10 dims value...

Re: Show Daily-Data in Monthly Dimension in a Chart

sunny_talwar — Fri, 09 Sep 2016 15:31:33 GMT

Sorry for not elaborating, but you need to use Continuous Axis on the presentation tab. Once you use that you will need to format your x-axis to view according to how you want to view it. The link helped with the second part, but I failed to mention that you will need to use Continuous Axis to do that