topic Re: set analaysis in QlikView

set analaysis

srinivasa1 — Mon, 03 Oct 2016 21:42:21 GMT

Hi ,

How I Can pass Employee ID as parameters/variables ( in set analaysis expersion) dynamically based on current selection for Employee ID

See below.

=sum({<EmployeeID={'60171'}>}Sales

I would like pass employee ID as variables here based on selection

Thanks for any help.

Re: set analaysis

sunny_talwar — Mon, 03 Oct 2016 21:46:23 GMT

Selection EmployeeID should flow through without you needing to specify anything. Have you tried Sum(Sales)?

Re: set analaysis

srinivasa1 — Mon, 03 Oct 2016 22:01:56 GMT

Thanks Sunny,

I need to pass EmployeeID values as variables in set analaysis expersion

for have defined filed event trigger would like to store selected value in variable's then pass this into expression.

Re: set analaysis

sunny_talwar — Mon, 03 Oct 2016 22:04:17 GMT

Can you may be elaborate why you need to do this? Are you restricting your expression using 1 to avoid any selections, but want to allow selection in EmployeeID field? For that, you can do this:

Sum({1<EmployeeID = P(EmployeeID)>}Sales)

Sum({1<EmployeeID = $::EmployeeID>}Sales)

Re: set analaysis

srinivasa1 — Mon, 03 Oct 2016 22:17:25 GMT

Thanks Sunny ,

My requirements us somehow different , I will try to crate sample example and send you ,

Basically am trying retrieve sales for Employee ID ='60171' when current selection of employee ID is '60560'

so am storing '60171' is in variable's then passing that variables into set analysis expression .

Example as below When I select employee ID ('60560')

sum({<EmployeeID={'60171'}>}Sales)

Thanks

Re: set analaysis

sunny_talwar — Mon, 03 Oct 2016 22:19:25 GMT

Now this makes a lot more sense. So what is the logic behind selecting 60171 when 60560 is selected?

Re: set analaysis

srinivasa1 — Mon, 03 Oct 2016 22:27:32 GMT

Thanks Sunny and sorry for any confusion

I defined Filed event trigger based on current selection(60560) to store my calculated employee ID(60171) in variable's (var1) now I plan to use them in set analysis expression see blow

sum({<EmployeeID={var1}>}Sales)

Thanks

Re: set analaysis

sunny_talwar — Mon, 03 Oct 2016 22:29:19 GMT

Try this may be:

Sum({<EmployeeID = {'$(=var1)'}>}Sales)

Sum({<EmployeeID = {'$(=$(var1))'}>}Sales)