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: 
Not applicable

Aggregation within Set analysis count

Good day,

I'm stuck on getting this expression to work for the past 2 days with no success, please can provide some advise as how i can can get this working?

The expression is as below:

count(



{<MODIFIED={'$(=min(MODIFIED))'} >}


{<WORKFLOW_STATUS_NAME={'DBText/Approval'}>}

aggr([NAME],[Product_Name2],[NAME]))

Currently the expression returns a count of 1 for each 'NAME' object grouped by its 'Product_Name' and only where the 'MODIFIED' date is the minimum date for that objects 'Product_Name' and where the 'WORKFLOW_STATUS' is as specified above.

This works in some cases, doesn't work in others, and assigns the count to the incorrect row.

The expression returns the a count of 1 for the specified criteria, but assigns the count to the incorrect row?

Any assitance would be much appreciated, thanks in advance for your effort.

I've attached the model below with sample data.

1 Solution

Accepted Solutions
Not applicable
Author

Hi All,

This was solved by using the following expression:

count(

if(WORKFLOW_STATUS_NAME='DBText/Editing',

aggr(FirstSortedValue(DISTINCT LAST_MODIFIER, MODIFIED), Product_Name2, NAME, WORKFLOW_STATUS_NAME)))

View solution in original post

1 Reply
Not applicable
Author

Hi All,

This was solved by using the following expression:

count(

if(WORKFLOW_STATUS_NAME='DBText/Editing',

aggr(FirstSortedValue(DISTINCT LAST_MODIFIER, MODIFIED), Product_Name2, NAME, WORKFLOW_STATUS_NAME)))