Solved: How to count positive values in a column - Qlik Community

ferha_jafri · ‎2013-11-26

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

VishalWaghole · ‎2013-11-27

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

View solution in original post

Report Inappropriate Content · ‎2013-11-26

if(column_Result > 0 , 1 ,0) and sum it

Report Inappropriate Content · ‎2013-11-26

Hi,

To count the positive values then use the below expression:

Count({<Coulmn1 = {'>0'}>} Coulmn1)

I am not sure, what do you mean by "How can i write an expression as that column is doing a division of two previos columns."?

ferha_jafri · ‎2013-11-26

no it is not like this ,i want to count no of rows for which the expression is positive as i have to divide some expression with that count.

Report Inappropriate Content · ‎2013-11-26

Hi Ferha,

Can you post sample script or attached qvw, so that we can check what exactly you are looking for.

Regards,

NR

ferha_jafri · ‎2013-11-26

this expression is not working.

ferha_jafri · ‎2013-11-26

The situation is that i want to calculate avg but if i use avg function it is dividing the result with total no of rows although i want to divide that expression with the count of positive values.

Report Inappropriate Content · ‎2013-11-26

Can you post a sample app?

Report Inappropriate Content · ‎2013-11-26

Hi,

Try to divide your expression with "Count({<Coulmn1 = {'>0'}>} Coulmn1)". Is it make sense?

sujeetsingh · ‎2013-11-26

Try this

=if(Left(Result,1)='-',Result,0)

See this sample for reference