Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
stevenoga1
New Contributor II

Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row

I have a pivot table.  The row values are server events (EVENT).  The columns are the range of dates across which the server events were opened(OPEN_DATE).  The measure is a count of the server events opened on each date (TCOUNT)

I want to create a Background Color expression that will cause a cell to turn red if ....  the total number of events opened on that date (TCOUNT) for a given server event (EVENT) exceeds AVG(TCOUNT) + 3* STDEV(TCOUNT) .   

I am pretty new with expressions so any assistance on this would be greatly appreciated. 

Tags (3)
Labels (1)
1 Solution

Accepted Solutions
stevenoga1
New Contributor II

Re: Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row

Solved it...  Thanks

View solution in original post

2 Replies
stevenoga1
New Contributor II

Re: Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row

Solved it...  Thanks

View solution in original post

stevenoga1
New Contributor II

Re: Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row

My Solution

=IF (RowNo() <> 0 AND ColumnNo() <> 0

AND Open_Date > MAX(ALL Open_Date)-40    /* only applies equation to the most current 40 days /*

AND SUM(Case_CNT) >= Aggr(Avg(Aggr(SUM(Case_CNT),Open_Date,Standard_Event)) + 3 * Stdev(Aggr(SUM(Case_CNT),Open_Date,Standard_Event)),Standard_Event), Red(), White())