topic Re: How to plot line chart stop at current month ? in App Development

How to plot line chart stop at current month ?

paulyeo11 — Tue, 08 Mar 2016 00:15:05 GMT

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

Re: How to plot line chart stop at current month ?

brunobertels — Tue, 08 Mar 2016 08:39:15 GMT

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

Re: How to plot line chart stop at current month ?

paulyeo11 — Tue, 08 Mar 2016 11:53:57 GMT

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

Re: How to plot line chart stop at current month ?

brunobertels — Tue, 08 Mar 2016 12:02:16 GMT

see attached

hope it helps

bruno

Re: How to plot line chart stop at current month ?

paulyeo11 — Tue, 08 Mar 2016 12:14:40 GMT

Hi sir

After i tick show other off , it work fine.

Re: How to plot line chart stop at current month ?

Keitaru — Fri, 01 Feb 2019 01:39:47 GMT

Does this work for running month too?