Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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:
Regards,
Brett
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.