Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
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
Highlighted
Champion
Champion

in dimesion

select date column and check supress null below

hope this helps

View solution in original post

3 Replies
Highlighted
Champion
Champion

in dimesion

select date column and check supress null below

hope this helps

View solution in original post

Highlighted
Not applicable

Well that was easy!

Thanks very much

Highlighted
Champion
Champion

see the attched screen shot