Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Set Analysis Query

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!

Tags (1)
3 Replies

Re: Set Analysis Query

HI

     Try like this,

    

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

     Hope it helps

Not applicable

Re: Set Analysis Query

Try like:

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

Re: Set Analysis Query

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?

Community Browser