topic Re: Removing data points from a chart in QlikView

Removing data points from a chart

Anonymous — Mon, 08 Aug 2016 13:57:20 GMT

Hello,

I am trying to remove specific data points from a chart. On the attached, I want to show all data points for the 5 days line, all but the last period (F1 on the chart) for 30 days and all but the last three data points for 90 days. Is there a way of removing these from the chart, but keeping the rest intact? This will then update each period, so next period, the 90 day data point for 201702 should appear.

Thanks,

Paul

Re: Removing data points from a chart

sunny_talwar — Mon, 08 Aug 2016 16:03:27 GMT

Do you want something like the attached?

Re: Removing data points from a chart

Anonymous — Tue, 09 Aug 2016 07:38:46 GMT

Yes, that's exactly it.

Re: Removing data points from a chart

sunny_talwar — Tue, 09 Aug 2016 08:18:21 GMT

I have posted the application for you to see, let me know if you need the expressions I used

Re: Removing data points from a chart

Anonymous — Tue, 09 Aug 2016 08:25:47 GMT

Apologies, I can't load the app - could you please post the expressions?

Re: Removing data points from a chart

sunny_talwar — Tue, 09 Aug 2016 10:05:47 GMT

30 days:

Sum({<F1 = {"$(='<=' & Date(AddMonths(Max(F1), -1), 'YYYYMM'))"}>}[30 days])

90 days:

Sum({<F1 = {"$(='<=' & Date(AddMonths(Max(F1), -3), 'YYYYMM'))"}>}[90 days])

Re: Removing data points from a chart

Anonymous — Tue, 09 Aug 2016 12:43:11 GMT

Fantastic - thank you!