Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))
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
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
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))
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'))