# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Contributor II

## Help with set analysis

Dear all,

I've to calculate how many customers have sales order value <> 0 in percentage , matching this value with the total customer number

Total customers:                                        10000

Total customers with sales order amount:     2000          PErc.  20%

I've prepared one table where I joined customers and orders and I'm trying without success the following:

count({<{"=Sum(OrderValue) <> 0"}>} distinct Customer )

but it doesn't work

What can I do ? Help please !!

4 Replies
Valued Contributor

## Re: Help with set analysis

Trie with this.

hope it helps you.

regards.

=num(

count( {\$<OrderValue <> {'0'}>} Customer ) /

count( {\$<OrderValue = >} Customer ),'#,00%')

Contributor II

## Re: Help with set analysis

I'm sorry but it doesn't work

Thanks

Valued Contributor

## Re: Help with set analysis

can you add me a qvw sample?

regards,

Contributor II

## Re: Help with set analysis

Unfortunatly I can't

Community Browser