topic Re: Need help with an expression in QlikView

Need help with an expression

Wed, 25 Jul 2012 09:37:00 GMT

Hello i've a problem with the expression below, i've refered to the help guide within Qlikview and I believe I am following the correct syntax.

count(if(mid(Move_Out_Date,4,2)='07'and left(Post_Code,4)='SO15'))

Re: Need help with an expression

deepakk — Wed, 25 Jul 2012 09:55:32 GMT

hi,

you need tao dd the field on which you need to count

count(if(mid(Move_Out_Date,4,2)='07'and left(Post_Code,4)='SO15' , FIELDNAME ) )

Deepak

Re: Need help with an expression

jagannalla — Wed, 25 Jul 2012 10:02:00 GMT

I think you are missing column to count

count(if(mid(Move_Out_Date,4,2)='07'and left(Post_Code,4)='SO15'))

=count(if(mid(Move_Out_Date,4,2)='07' and left(Post_Code,4)='SO15' ,ColumnName))

Re: Need help with an expression

Wed, 25 Jul 2012 10:17:51 GMT

Thanks guys, I didnt have a field I wanted to use as count so I added the field '1 as count' in the same table as move out date so the final expression looked like this :- count(if(mid(Move_Out_Date,4,2)='08'and left(Post_Code,4)='SO15','Count'))