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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Need Help..

Hi All,

I have one pivot table,

Dimensions :  ID, Month and Status

Measure:  Count(Status)

I want show only Count(ID) greater than 2, i have duplicate ID's depends on status....

I am using in Dimension if(Count(ID)>2, ID)

But, it showing error.. any thing wrong here....

1 Solution

Accepted Solutions
paulwalker
Creator III
Creator III
Author

Yeah, I got it..

I have used this expression...

=if(Aggr(Count(ID),ID)>1,ID)

View solution in original post

4 Replies
Chanty4u
MVP
MVP

hi

Please try this once

if(count(distinct(id)>2,id)

Thank you

Suresh

paulwalker
Creator III
Creator III
Author

Yeah, I got it..

I have used this expression...

=if(Aggr(Count(ID),ID)>1,ID)

Chanty4u
MVP
MVP

good

timanshu
Creator III
Creator III

Hi,

Kindly mark question as answered