How to use an If or When condition in a Variable

Tue, 17 Sep 2013 02:05:29 GMT

Hi,

I need to make a change to an existing variable so that it only shows results for when 'Status' is 'Active'.

This is the variable: sum([Counter_Interviews])/(count(distinct [Fin Period])*4)/count(distinct Planner)

At the moment this formula taking all interviews, dividing them by 4 and then dividing them again by the number of planners. What I want it do to is to only take interviews for planners who have an 'Active' status, divide this by 4, and then divide this by the number of planners with an 'active' status.

Any suggestions?

Thanks

Re: How to use an If or When condition in a Variable

Sokkorn — Tue, 17 Sep 2013 02:13:31 GMT

Hi,

Maybe you can try this

(Sum({$<Status={'Active'}>} [Counter_Interviews])/4)/

Count({$<Status={'Active'}>} Distinct Planner)

Regards,

Sokkorn

topic How to use an If or When condition in a Variable in QlikView

How to use an If or When condition in a Variable

Re: How to use an If or When condition in a Variable