Count

[Venkatsj]

Hi,

Days
1
0
0
5
6
5
5
21
1
1
4
1
2
4
3
92

From the above table how to count the rows which has value greater than and equal to 5? It should exclude the blank cells also. Can anyone help me with the expression? 

[Qlik1_User1]

@Venkatsj You can do the same at backend

load * from table where Days>=5;

[avinashelite]

try like this 

where

Days>=5 and len(trim(Days))>0

in expression 

if(Days>=5 and len(trim(Days))>0,Days)