Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

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
Valued Contributor

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

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

4 Replies
brunobertels
Valued Contributor

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

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
Valued Contributor II

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

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
Valued Contributor

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

see attached

hope it helps

bruno

Highlighted
paulyeo11
Valued Contributor II

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

Hi sir

After i tick show other off , it work fine.

after tick ok.png

Community Browser