topic Need some examples for Expressions in QlikView

Need some examples for Expressions

Tue, 30 Jul 2013 09:40:25 GMT

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:

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

Thanks in advance.

Tue, 30 Jul 2013 10:20:44 GMT

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))
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))