Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
lohitala
Contributor
Contributor
‎2019-03-13 02:13 PM

Ignoring specific dimension in AGGR function

Hello All, I am ignoring dimension Dim1 and Dim2.but my measure its is still reacting when i select those dimension .

count({<Dim1=,Dim2=>}aggr(if(round(
(Sum({1<Dim1={'CDIFF'},Dim1=,Dim2=>}Numerator)
/sum({1<Dim1={'CDIFF'},Dim1=,Dim2=>}Denominator)),0.0001)
<GrtrThn,Dim1),GrtrThn,srnumber,Dim1))

467 Views
0 Likes
1 Reply
Brett_Bleess
Former Employee
Former Employee
‎2019-03-21 05:10 PM

Try going to the following link and search on AGGR, I got quite a few hits, and I did not want to kill you with links, figured it was better to let you have a direct look to see if anything there may help out here:

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

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.
434 Views
0 Likes