topic Re: Set analysis with expression in QlikView

Set analysis with expression

Tue, 24 Mar 2015 10:08:57 GMT

Hi Guys,

I have the following columns in my table:

Column1 Column2 Column1 - Column2 (this is an expression)

1 1 0%

4 2 50%

10 10 0%

3 2 33%

5 2 60%

Column1 - Column2 will always be positive:

What I need is to return the count of the numbers in Column1-Column2 greater than 0%.

My formula, at the moment, looks like this:

=Count({< [Column1 - Column2] = {'>0%'} >} [Column1 - Column2])

But this doesn't work.

Any advice is much appreciated!

Thanks

anbu1984 — Tue, 24 Mar 2015 10:13:19 GMT

Are you trying to do count in text box?

=Count(If( [Column1] - [Column2] > 0,1))

awhitfield — Tue, 24 Mar 2015 11:17:23 GMT

Hi Adrian,

what is the expression you are using in the third column please?

Andy

MK_QSL — Tue, 24 Mar 2015 11:19:31 GMT

=SUM(Aggr(COUNT({<Column1 = {"=Column1 > Column2"}>}1),Column1))