topic Re: Count an expression in QlikView

Count an expression

Wed, 13 May 2015 22:09:04 GMT

Good day.

My english isnt good, so I'll try to explain. I have a percentage value, you get what expression of the average current year divided by the average last year , this percentage gives me result in a negative or positive value.

I need to know how I could count how many of these results are negative or positive.

For example:

(100/150) -1 = -0.33

(175/200)-1 = -0.12

(225/125)-1 = 0.8

Header 1	Header 2	Header 3	Header 4
A	100	150	-33%
B	175	200	-12%
C	225	125	80%

To count the result would be one positive and 2 negative.

How I make this count of a calculated expression ???

Re: Count an expression

anbu1984 — Thu, 14 May 2015 05:01:29 GMT

Positive count expr: Count(If([Header 2] > [Header 3],1)

Negative count expr: Count(If([Header 2] < [Header 3],1)

Re: Count an expression

jagan — Thu, 14 May 2015 05:31:55 GMT

Hi,

Try like this

For Positive Count : Sum(If([Header4] >= 0, 1))

For Negative Count : Sum(If([Header4] < 0, 1))

Hope thsi helps you.

Regards,

Jagan.