Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lylererger
Creator II
Creator 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
petter
Partner - Champion III
Partner - Champion III

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
lylererger
Creator II
Creator II
Author

petter
Partner - Champion III
Partner - Champion III

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).

lylererger
Creator II
Creator II
Author

Thanks a lot Petter