Need help with an expression

[#1]

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

[deepakk · Accepted solution]

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

[jagannalla]

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

[#4]

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