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 Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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: 
Not applicable
‎2013-07-30 05:40 AM

Need some examples for Expressions

Hi,

Can someone provide examples for Expressions for where and if statements. I am a beginner and could not find relevant examples in the tutorial.

I am looking for the correct syntax for the below expression:

  1. count (NUMBER) where ACK is not null and priority is low and ACKTIME < 3600
  2. count (NUMBER) where STATUS = "Resolved or Closed" and CLOSEDATE is between "dd-mm-yyyy" and "dd-mm-yyyy"

Thanks in advance.

624 Views
0 Likes
1 Reply
Not applicable
‎2013-07-30 06:20 AM
Author

  1. count (NUMBER) where ACK is not null and priority is low and ACKTIME < 3600 Ans: count(if(isnull(ACK)=0 and priority='low' and ACKTIME<3600,NUMBER))
  2. count (NUMBER) where STATUS = "Resolved or Closed" and CLOSEDATE is between "dd-mm-yyyy" and "dd-mm-yyyy"   Ans: Count(if(wildmatch(STATUS,'Resolved','Closed') and CLOSEDATE>=date('27-05-2012','dd-mm-yyyy') and CLOSEDATE<=date(today(),'dd-mm-yyyy'),NUMBER))
397 Views
0 Likes