If Aggr

[#1]

Hi fellow Qlikers

I've attached a file.  The chart produces the results I want as well as it maintains dynamic selection.  But using this expression, I have to use "Sum of Rows" to get the totals.  I need to produce the same results but for the Count to be in the Expression, not the Sum of Rows, so I can create the 3 text objects showing the total Passed, Failed, and Total values while maintaining the dynamic selection.

Thank you!!

[swuehl]

Maybe like attached?

[Anonymous]

Hi Mark,

Use this expressions:

count({<Status={'Passed'}>} if(Run_ID=aggr(NODISTINCT max(Run_ID),Dim1,Dim2,Test_ID),Test_ID))

count({<Status={'Failed'}>} if(Run_ID=aggr(NODISTINCT max(Run_ID),Dim1,Dim2,Test_ID),Test_ID))

count({<Status={'*'}>} if(Run_ID=aggr(NODISTINCT max(Run_ID),Dim1,Dim2,Test_ID),Test_ID))

Regards!!

[#4]

Wonderful!!  Thank you

[#5]

Stephen,

Any idea how I would create an action in a text object so that when I click on any of the above expressions, the number of Test_ID's will be filtered accordingly?

[#6]

Sorry, I meant Manuel.

[#7 · Accepted solution]

I figured it out.

='('&Concat({<Status={'Passed'}>}distinct if(Run_ID=aggr(NODISTINCT max(Run_ID),Test_ID),Test_ID),'|')&'))'