Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Ignore certain fields in Set Analysis

Hello,

Hope everyone is fine.

We have an expression which calculates the total average of our technicians and the supervisors.  When we click on a supervisor then the average changes.

We want the average to only change on when date is selected.  We do not want the average to change when technician or supervisor is selected.

We are using a variable with the following expression to calculate the Average.

num(count({<Contractor_Name= {'FHC'}, Task_st2 = {'Completed'}>}Task_st2)/sum(aggr(count({<Contractor_Name= {'FHC'}>}distinct Technician_ID),newDate,Technician_ID)), '##.##')


How can we ignore the Technician_ID and the Supervisor_ID when we select the Technician and Supervisor so that the Average do not change due to selection.


Will appreciate if someone can assist.


Thanks.

1 Solution

Accepted Solutions
Highlighted

Try this:

Num(Count({<Contractor_Name= {'FHC'}, Task_st2 = {'Completed'}, Technician_ID, Supervisor_ID>}Task_st2)/Sum({<Technician_ID, Supervisor_ID>} Aggr(Count({<Contractor_Name= {'FHC'}, Technician_ID, Supervisor_ID>} DISTINCT Technician_ID), newDate, Technician_ID)), '##.##')

View solution in original post

2 Replies
Highlighted

Try this:

Num(Count({<Contractor_Name= {'FHC'}, Task_st2 = {'Completed'}, Technician_ID, Supervisor_ID>}Task_st2)/Sum({<Technician_ID, Supervisor_ID>} Aggr(Count({<Contractor_Name= {'FHC'}, Technician_ID, Supervisor_ID>} DISTINCT Technician_ID), newDate, Technician_ID)), '##.##')

View solution in original post

Highlighted
Partner
Partner

Sunny,

Thanks a lot for the correct answer.  I was almost there as I was missing Sum({<Technician_ID, Supervisor_ID>}

before the aggr part.

I read it in one of the questions that if you want to ignore the dimensions then include them inside the <> in the set analysis. 

Thanks once again for your assistance.