topic Re: Associated Field Selection in QlikView

Associated Field Selection

Thu, 12 Feb 2015 06:39:53 GMT

Morning.

Need some help please,

I have a listbox, lets call it team leader, there is a feild associated to that team leader, called department, when i select the team Leader, i want a variable to automatically assign the value of the associated department.

I then want to use that variable to show that department statistics using the formulae

(sum({1<Dept='$(vdeptfqc)'>} percentage)/count(distinct {1<Dept='$(vdeptfqc)'>} call_reference_no))/100

Please Assist

Re: Associated Field Selection

Gysbert_Wassenaar — Thu, 12 Feb 2015 08:56:30 GMT

Why do you want to use a variable?

Does this expression give you the result you need?

(sum({1<Dept=p(Dept)>} percentage)/count(distinct {1<Dept=p(Dept)>} call_reference_no))/100

Re: Associated Field Selection

Thu, 12 Feb 2015 09:40:31 GMT

Hi there,

Thats pure awesomeness, now explain to me what its doing please?

Re: Associated Field Selection

Gysbert_Wassenaar — Thu, 12 Feb 2015 09:45:15 GMT

{1<Dept=p(Dept)>} means disregard all selections, but filter the Dept field to those Dept values that are possible values given the selections made.