Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stevenoga1
Contributor II
Contributor II

Using Aggr with a Pivot Table to populate a row of cells with the MAX Row Value

Using a filtered set of values from the app....

I have a Pivot Table of values that appears as below when I set MEASURES to SUM(Case_CNT).

The Dimensions are STANDARD_EVENT and OPEN_DATE

Standard_Event7/14/197/13/197/12/197/11/19
%Job completed abnormally%15413814990
%Service%is not started. Current state is stopped%425813549


I want i to populate each cell within a row of the Pivot Table with the MAX value for the row.  I want it to look like this. 

Standard_Event7/14/197/13/197/12/197/11/19
%Job completed abnormally%154154154154
%Service%is not started. Current state is stopped%135135135135

 

Using the following expression....

 =MAX(Aggr(MAX(Aggr(SUM(Case_CNT),Open_Date,Standard_Event)),Standard_Event))

I get the table below.  Any ideas as to why the Pivot Table appears the way it does?

Any ideas as to how I get this to appear the way I need it?

Standard_Event7/14/197/13/197/12/197/11/19
%Job completed abnormally%-154--
%Service%is not started. Current state is stopped%--135-

 

Thanks

Labels (2)
2 Replies
udayreddy06
Contributor II
Contributor II

Hello,

You have to do it at the script level. Please check if the script in the application make sense.

Regards,
Uday

stevenoga1
Contributor II
Contributor II
Author

Uday...

The Dates and Events represented in the table are changeable dynamically in the app so I do not believe the scripting approach will work.   I appreciate the suggestion though.

This issue as presented in my question is a simplification of the true issue I am working.  I  need to calculate a value based upon the ROW content.  Specifically an Upper Control Limit (Mean+2*STDEV).   I will be comparing this value against each cell in the Row.  Cells which exceed this limit are to be turned Red. 

For some reason the AGGR function I have created is unable to apply the ROW Values it produces in a consistent fashion across all the Cells in each Row.  Engaging in the simplified example highlighted this as the issue. 

I have attached a QVF file that has both the simplified example as well as my real issue.   Any additional thoughts on your part would be greatly appreciated.