topic Re: IF function with multiple values in QlikView

IF function with multiple values

Wed, 15 Jul 2015 10:21:43 GMT

Hi All,

Can we use the below script while loading:

sum(if(match(A,'[00:30 hrs]','[01:00 hrs]','[01:30 hrs]') and B='Processed', 1,0) ) as C

If not, please suggest an alternative.

My requirement is to get the count of total records in a field called C where

A=00:30 hrs , 01:00 hrs , 01:30 hrs

and

B=Processed

TIA

Regards,

Rishikesh

MayilVahanan — Wed, 15 Jul 2015 10:24:30 GMT

Try like this'

In Script:

if(match(A,'[00:30 hrs]','[01:00 hrs]','[01:30 hrs]') and B='Processed', 1,0) as C

Then in front end, you can use Sum(C)

prashantbaste — Wed, 15 Jul 2015 10:39:13 GMT

Hi Kumar Rishikesh

You can use

sum(if(match(A,'[00:30 hrs]','[01:00 hrs]','[01:30 hrs]') and B='Processed', 1,0) ) as C

but then you need to use groupby with respect too some field to get desired result.

Hope this will be helpful for you.

Regards,

Prashant P Baste

Wed, 15 Jul 2015 11:01:09 GMT

Tha nks Mayil and Prasant