Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help with an expression

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

1 Solution

Accepted Solutions
deepakk
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

3 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

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
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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