Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

If Aggr

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!!

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: If Aggr

I figured it out.

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

6 Replies
MVP
MVP

Re: If Aggr

Maybe like attached?

manucamon
Valued Contributor III

Re: If Aggr

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!!

Not applicable

Re: If Aggr

Wonderful!!  Thank you

Not applicable

Re: If Aggr

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?

Not applicable

Re: If Aggr

Sorry, I meant Manuel.

Not applicable

Re: If Aggr

I figured it out.

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