Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
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 !!

Thanks in advance

4 Replies
fdelacal
Valued Contributor

Re: Help with set analysis

Trie with this.

hope it helps you.

regards.

=num(

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

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

bibopipo
Contributor II

Re: Help with set analysis

I'm sorry but it doesn't work

Thanks

fdelacal
Valued Contributor

Re: Help with set analysis

can you add me a qvw sample?

regards,

bibopipo
Contributor II

Re: Help with set analysis

Unfortunatly I can't