topic Re: Set Analysis Query in QlikView

Set Analysis Query

Tue, 31 Jul 2012 13:40:23 GMT

Greetings All,

Can anyone please tell me how to write this query to find the top customers by using rank():

IF(Picking = 'Yes', COUNT(customer)/TotalOrder, COUNT(customer)/TotalOrder).

Many Tx!

MayilVahanan — Tue, 31 Jul 2012 13:41:56 GMT

Try like this,

=Count({<Picking = {'Yes'} >} Customer) / TotalOrder

Hope it helps

Tue, 31 Jul 2012 13:45:26 GMT

Try like:

Count({Picking={'Yes'}>} customer)/TotalOrder

CELAMBARASAN — Tue, 31 Jul 2012 14:20:50 GMT

Hi,

First of all in your expression is if condition is needed?Both if and else part are same.

Can you explain little more breifer?