Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

Tags (3)
1 Solution

Accepted Solutions
Highlighted
SunilChauhan
Esteemed Contributor

Re: Removing unmateched dates from charts

in dimesion

select date column and check supress null below

hope this helps

View solution in original post

3 Replies
Highlighted
SunilChauhan
Esteemed Contributor

Re: Removing unmateched dates from charts

in dimesion

select date column and check supress null below

hope this helps

View solution in original post

Not applicable

Re: Removing unmateched dates from charts

Well that was easy!

Thanks very much

SunilChauhan
Esteemed Contributor

Re: Removing unmateched dates from charts

see the attched screen shot