Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Set Analysis within Set Analysis Expression

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. 

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Set Analysis within Set Analysis Expression

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. 

View solution in original post

2 Replies
Highlighted
Digital Support
Digital Support

Re: Set Analysis within Set Analysis Expression

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Creator III
Creator III

Re: Set Analysis within Set Analysis Expression

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. 

View solution in original post