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: 
Not applicable

Removing unmateched dates from charts

Newbie here....

Plotting a line graph with dates, and the defualt is giving me an extra data on the far right of the x-axis where the data has come back as null. (I've joined a Sales_date to a calendar table).

I'd either like to remove these values in the script, or simply hide from the chart.

Any help appreciated, thanks in advance.

Capture.PNG.png

1 Solution

Accepted Solutions
SunilChauhan
Champion
Champion

in dimesion

select date column and check supress null below

hope this helps

Sunil Chauhan

View solution in original post

3 Replies
SunilChauhan
Champion
Champion

in dimesion

select date column and check supress null below

hope this helps

Sunil Chauhan
Not applicable
Author

Well that was easy!

Thanks very much

SunilChauhan
Champion
Champion

see the attched screen shot

Sunil Chauhan