Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
Hi Kumar Rishikesh
You can use
but then you need to use groupby with respect too some field to get desired result.
Hope this will be helpful for you.
Prashant P Baste
Try like this'
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)
Tha nks Mayil and Prasant