Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
see attached
hope it helps
bruno
Hi sir
After i tick show other off , it work fine.
Does this work for running month too?