Skip to main content

Qlik

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
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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))

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