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
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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: 
bob1231
Contributor
Contributor
‎2021-05-05 06:52 AM

count with conditions

hello i'm new to qlik sense and just wanted to know how to do this task

i have 3 columns: order, date1, date2

i want to count how many orders have date1-date2 greater than 0 

i used this command but it's not showing anything until i filter and choose a date but when i choose more than 1 date it doesn't show anything 

count(if((date1-date2)>0,order))

 

336 Views
0 Likes
0 Replies