Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to plot line chart stop at current month ?

Hi All

I have a line chart 1 , it can plot the line from jan till Feb . as march no data , so the line stop there.

Because i set the add-on , and i don't tick the show missing value. So it does not display the rest of the month.

In chart 2 i add last year sales line. it is possible to force it also display till Feb ? even it have value in march last year.

I can achieve this in QV , but no in QS.

Paul

1 Solution

Accepted Solutions
brunobertels
Master
Master

Hi Paul

may be just add a limitation in your month dimension :

month(today())-1

it's force your chart to display only previous month :

regards

View solution in original post

5 Replies
brunobertels
Master
Master

Hi Paul

may be just add a limitation in your month dimension :

month(today())-1

it's force your chart to display only previous month :

regards

paulyeo11
Master
Master
Author

Hi Bruno

I look at the chart , it is what i am look for. thank you very much.

I try to do what you said , but i get Other on X Axis and Jan sales. Not sure where i go wrong. it is possible to send me QVF file ? So i can figure out where i go wrong.

Paul

brunobertels
Master
Master

see attached

hope it helps

bruno

paulyeo11
Master
Master
Author

Hi sir

After i tick show other off , it work fine.

after tick ok.png

Keitaru
Creator
Creator

Does this work for running month too?