How to count positive values in a column

[ferha_jafri]

Hello everyone,

It is very urgent ,the issue is i want to count no of positive values greater that 0 in a column.How can i write an expression as that column is doing a division of two previos columns.

Thanks in advance

Ferha Jafri

[sujeetsingh]

It seems Jafri got some answer anywhere but forgot to mention in this thread

[VishalWaghole · Accepted solution]

Hi Ferha,

Make Flag for negative and positive values on script level like

if(Column_Value > 0,'POSITIVE','NEGATIVE') as FLAG

then use this flag for in your count expression like

Count({<FLAG = {'POSITIVE'}>}Column_Value)

Thanks and Regards,

Vishal Waghole

[vikasmahajan]

While Loading Data into Qlikview You can create FLAG Negative and Positive and use in expression.

Vikas