Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Removing data points from a chart

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

1 Solution

Accepted Solutions
sunny_talwar

30 days:

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

90 days:

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

View solution in original post

6 Replies
sunny_talwar

Do you want something like the attached?

Capture.PNG

Anonymous
Not applicable
Author

Yes, that's exactly it.

sunny_talwar

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

Anonymous
Not applicable
Author

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

sunny_talwar

30 days:

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

90 days:

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

Anonymous
Not applicable
Author

Fantastic - thank you!