Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Announcements

Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: **Register**

- Qlik Community
- :
- Forums
- :
- Analytics
- :
- New to Qlik Sense
- :
- Re: Highlight Consecutive Values Control Chart

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

qlikfresh

Contributor III

2020-10-30
04:23 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Highlight Consecutive Values Control Chart

Hi All 🙂

I have a process control chart and would like to highlight the data points say for example if 6 points are consecutively on one side of the mean however I am unsure how to write this.

Please see pic to see what I would like to highlight, many thanks! 😄

681 Views

1 Solution

Accepted Solutions

GaryGiles

Specialist

2020-11-12
04:25 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

This is not pretty, but it should work. You would use the Above function to check previous and following points. Set as Color as Expression. This is the start. You would need to finish the combinations where I have . . . and replace Value and SDate with you measure and dimension.

if((sum(Value)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),3)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),4)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),5)>(sum(Total Value)/count(Distinct Total SDate))) or

(sum(Value)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),-1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),3)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),4)>(sum(Total Value)/count(Distinct Total SDate))) or

(sum(Value)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),-2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),-1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),3)>(sum(Total Value)/count(Distinct Total SDate))) or

. . . .

,Red(),Black())

3 Replies

Brett_Bleess

Former Employee

2020-11-12
03:24 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I believe that is likely going to need Set Analysis, but I am not sure, the following may help if that is the case:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Here is the Help link to it too:

Sorry I am not more help, I am not very good at the dev side of things, more of a backend guy, apologies.

Regards,

Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.

I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

GaryGiles

Specialist

2020-11-12
04:25 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

This is not pretty, but it should work. You would use the Above function to check previous and following points. Set as Color as Expression. This is the start. You would need to finish the combinations where I have . . . and replace Value and SDate with you measure and dimension.

if((sum(Value)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),3)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),4)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),5)>(sum(Total Value)/count(Distinct Total SDate))) or

(sum(Value)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),-1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),3)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),4)>(sum(Total Value)/count(Distinct Total SDate))) or

(sum(Value)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),-2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),-1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),3)>(sum(Total Value)/count(Distinct Total SDate))) or

. . . .

,Red(),Black())

GaryGiles

Specialist

2020-11-12
05:32 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

This isn't pretty, but it should highlight the correct values. In Color by Expression, this uses the Above function to check previous and following values. This is just the start, you will need to finish the pattern for possible combinations where I have . . . and replace Value with your measure and SDate with you Dimension.

if((sum(Value)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),3)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),4)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),5)>(sum(Total Value)/count(Distinct Total SDate))) or

(sum(Value)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),-1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),3)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),4)>(sum(Total Value)/count(Distinct Total SDate))) or

(sum(Value)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),-2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),-1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),1)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),2)>(sum(Total Value)/count(Distinct Total SDate)) and

above(sum(Value),3)>(sum(Total Value)/count(Distinct Total SDate))) or

. . . .

,Red(),Black())

624 Views