topic Re: If Aggr in QlikView

If Aggr

Tue, 16 Aug 2016 20:44:13 GMT

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

Re: If Aggr

swuehl — Tue, 16 Aug 2016 22:17:23 GMT

Maybe like attached?

Re: If Aggr

Anonymous — Wed, 17 Aug 2016 06:40:18 GMT

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

Re: If Aggr

Wed, 17 Aug 2016 13:51:13 GMT

Wonderful!! Thank you

Re: If Aggr

Wed, 17 Aug 2016 21:35:20 GMT

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?

Re: If Aggr

Wed, 17 Aug 2016 21:36:23 GMT

Sorry, I meant Manuel.

Re: If Aggr

Wed, 17 Aug 2016 21:59:07 GMT

I figured it out.

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