Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Set analysis with expression

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

1 Solution

Accepted Solutions
anbu1984
Honored Contributor III

Re: Set analysis with expression

Are you trying to do count in text box?

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

3 Replies
anbu1984
Honored Contributor III

Re: Set analysis with expression

Are you trying to do count in text box?

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

awhitfield
Esteemed Contributor

Re: Set analysis with expression

Hi Adrian,

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

Andy

Re: Set analysis with expression

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

Community Browser