topic Re: How to count positive values in a column in QlikView

How to count positive values in a column

ferha_jafri — Tue, 26 Nov 2013 09:03:51 GMT

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

Re: How to count positive values in a column

Tue, 26 Nov 2013 09:06:45 GMT

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

Re: How to count positive values in a column

Tue, 26 Nov 2013 09:10:58 GMT

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."?

Re: How to count positive values in a column

ferha_jafri — Tue, 26 Nov 2013 09:13:33 GMT

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.

Re: How to count positive values in a column

Tue, 26 Nov 2013 09:17:17 GMT

Hi Ferha,

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

Regards,

Re: How to count positive values in a column

ferha_jafri — Tue, 26 Nov 2013 09:18:30 GMT

this expression is not working.

Re: How to count positive values in a column

ferha_jafri — Tue, 26 Nov 2013 09:20:59 GMT

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.

Re: How to count positive values in a column

Tue, 26 Nov 2013 09:21:40 GMT

Can you post a sample app?

Re: How to count positive values in a column

Tue, 26 Nov 2013 09:22:01 GMT

Hi,

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

Re: How to count positive values in a column

sujeetsingh — Tue, 26 Nov 2013 09:29:28 GMT

Try this

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

See this sample for reference

Re: How to count positive values in a column

sujeetsingh — Wed, 27 Nov 2013 03:27:32 GMT

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

Re: How to count positive values in a column

VishalWaghole — Wed, 27 Nov 2013 05:22:58 GMT

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

Re: How to count positive values in a column

vikasmahajan — Wed, 27 Nov 2013 06:16:03 GMT

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

Vikas