Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor II

Show 13 Months in Line Chart by Years

Hi, friends!

Any ideas - how to show that kind of diagramm.

Снимок.PNG

It's like a challenge.

Waiting for any ideas, may be examples.

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Show 13 Months in Line Chart by Years

It can be achieved by creating the additional month with the right value in your data model:

2017-09-09 16_57_24-Edit Script [C__Users_Petter_Documents_13 months plot.qvw].png

And a straightforward line chart would look like this:

2017-09-09 16_56_46-QlikView x64 - [C__Users_Petter_Documents_13 months plot.qvw].png

The downside is that you have to be careful to exclude the 13th month in all other calculations or you will get incorrect results. That can be achieved with Set Expressions (Set Analysis).

View solution in original post

3 Replies
Highlighted
Contributor II

Re: Show 13 Months in Line Chart by Years

Highlighted
MVP
MVP

Re: Show 13 Months in Line Chart by Years

It can be achieved by creating the additional month with the right value in your data model:

2017-09-09 16_57_24-Edit Script [C__Users_Petter_Documents_13 months plot.qvw].png

And a straightforward line chart would look like this:

2017-09-09 16_56_46-QlikView x64 - [C__Users_Petter_Documents_13 months plot.qvw].png

The downside is that you have to be careful to exclude the 13th month in all other calculations or you will get incorrect results. That can be achieved with Set Expressions (Set Analysis).

View solution in original post

Highlighted
Contributor II

Re: Show 13 Months in Line Chart by Years

Thanks a lot Petter