topic Re: Greater than 0% in Set analysis in QlikView

Greater than 0% in Set analysis

Fri, 24 Jun 2011 12:50:17 GMT

Hi,

I am trying to get all values greater than 0% using this set analysis expression, but I have no idea how to achieve this.

My expression is : (sum({$<Name={'AAA'} >} Value)/100)

Any ideas would be appreciated.

Many thanks

kaushiknsolanki — Sat, 25 Jun 2011 11:01:49 GMT

Hi,

Can you provide the sample qvw file.

Regards,

Kaushik Solanki

jonathandienst — Sat, 25 Jun 2011 13:03:32 GMT

This expression may be what you need:

sum({$<Name={'AAA'}, Value={">=0"}>} Value)/100

Regards

Jonathan