Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Filter based Caluculation-Qlik Sense

 

I have a table having “Team Member”  , “Team Member Profession”  ,” No.Booked” , “No.Available” fields

 

I have filters “Team Member filter”, “Profession filter”

 

When I select one Team Member from filter , I can get “UTILIZATION” kpi figure with following formula

 

Sum([No.Booked])/Sum([No.Available])

 

And when I filter Team Member, its associated “Professions remain active in “Profession Filter” while all other gets disable(Greyed). When I select that Profession from filter pan,  I  get another KPI figure for profession utilization with following formula.

 

SUM({<[Team Member]=>}[No.Booked]) / SUM({<[Team Member]=>}[No.Available])

 

 

But my requirement is that when I select Team Member it should give me the Profession utilization figure without explicitly selecting filtered out “Profession” based on Team Member Selected. How can I change my profession utilization formula to achieve this.

 

Please Help. Thanks

 

1 Solution

Accepted Solutions

Re: Filter based Caluculation-Qlik Sense

Try this

Sum({<[Team Member] =, Profession = p(Profession)>}[No.Booked]) / Sum({<[Team Member] =, Profession = p(Profession)>}[No.Available])

2 Replies

Re: Filter based Caluculation-Qlik Sense

Try this

Sum({<[Team Member] =, Profession = p(Profession)>}[No.Booked]) / Sum({<[Team Member] =, Profession = p(Profession)>}[No.Available])

Not applicable

Re: Filter based Caluculation-Qlik Sense

It works. Great. Thanks

Community Browser