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
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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: 
maheshgandem
Contributor II
Contributor II
‎2017-11-08 06:54 AM

count if help

Hi, am new to Qlik and need 1 help. Am trying to fetch customer_id data who have given complaints for more than 2 times. currently using =Count({<reopen_count={'>2'} however, when fetching the data, full data is getting as an output, pls help

1,138 Views
3 Replies
maheshgandem
Contributor II
Contributor II
‎2017-11-08 06:55 AM
Author

=Count({<customer_id={'>2'}

1,076 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2017-11-09 08:13 AM

Perhaps this?

=Count({<customer_id={"=Count(customer_id) > 2"} customer_id)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
1,076 Views
agigliotti
MVP
MVP
‎2017-11-09 08:37 AM

do you have a field named "reopen_count" ?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
1,076 Views
0 Likes