topic Re: Ignore certain fields in Set Analysis in QlikView

Ignore certain fields in Set Analysis

sjhussain — Sun, 17 Jan 2016 17:37:17 GMT

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.

Re: Ignore certain fields in Set Analysis

sunny_talwar — Sun, 17 Jan 2016 17:47:16 GMT

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)), '##.##')

Re: Ignore certain fields in Set Analysis

sjhussain — Mon, 18 Jan 2016 16:52:06 GMT

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.