Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
chauhans85
Esteemed Contributor

Re: Removing unmateched dates from charts

in dimesion

select date column and check supress null below

hope this helps

3 Replies
chauhans85
Esteemed Contributor

Re: Removing unmateched dates from charts

in dimesion

select date column and check supress null below

hope this helps

Not applicable

Re: Removing unmateched dates from charts

Well that was easy!

Thanks very much

chauhans85
Esteemed Contributor

Re: Removing unmateched dates from charts

see the attched screen shot

Community Browser