Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
I figured it out.
='('&Concat({<Status={'Passed'}>}distinct if(Run_ID=aggr(NODISTINCT max(Run_ID),Test_ID),Test_ID),'|')&'))'
Maybe like attached?
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!!
Wonderful!! Thank you
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?
Sorry, I meant Manuel.
I figured it out.
='('&Concat({<Status={'Passed'}>}distinct if(Run_ID=aggr(NODISTINCT max(Run_ID),Test_ID),Test_ID),'|')&'))'