Set Analysis within Set Analysis Expression

[ZoeM]

Hi Community,

I am building a dimension that will  have detail and I want to add an additional expression for the Uncontained/Contained Values as below:

Current Expression:

=Aggr( Concat( {$<[Date Type]={'VPP Dates'}, [Declaration Status]={'Next'}>} DISTINCT Region&' '&

[MY Program]&chr(10)&chr(5867)&' Current Gateway - <'&Gateways&'>'&' ('&Date([Date],'DD-MMM-YY')&')'& chr(10)&chr(5867)&
' Rating - '&Rating&' '&
'| UnContained Issues: '&
'| Contained Issues: '&
chr(10)&chr(5867)&

' Projected Completion - '&Projected_Completion&chr(10)&chr(5867)&
' Next Review - '&Mgmt_Review&chr(10)&chr(10)),[MY Program])

Current Uncontained/Contained Expression in text box:

Num(Count( {$<[Issue Category]={'UnContained'}, [Declaration Status]={'Next'},Year=>} [New Issue ID]) ,'#,###;(#,###)')

How can I add this expression to the above? I am getting an error (blank) when I try even though it says expression ok.

Any help will be appreciated. 

[Brett_Bleess]

I would recommend having a look at the following Design Blog post to see if that may provide any clues, and there are some additional post links at the bottom of the post too, and there are also further Set Analysis related items in this are, so I will post the base URL too, so you can search further if you wish.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Here is the Help link too:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett

[ZoeM · Accepted solution]

Thanks Brett.

I took a slightly different approach. I had to prepare my data and summarize the Uncontained / Contained fields before bringing them into the tool and from there i could add them to the dimension expression. It was much easier this way.