topic Set Analysis to Include Selected Dimension in QlikView

Set Analysis to Include Selected Dimension

Dayna — Tue, 08 Mar 2011 11:07:48 GMT

Hello All,

Sure this is an easy one, what I am trying to do is for each user I want to use their effort and mutliple it by a variable - each user has a variable assigned to it. I originally used Set Analysis but this may need tweaking. It works fine when looking at an overview of all users, and when you change the variable value the chart changes - but when you select an individual user it still shows the overview.

What I really need, is something that will change when I select user(s) and to multiple their effort by the variable.

This is what I currently have:



sum({$<SUN_OwnerAccount = {'User1'}>} vRB*SUN_IH_EffortTime)+

sum({$<SUN_OwnerAccount = {'User2'}>} vHSJ*SUN_IH_EffortTime)+

sum({$<SUN_OwnerAccount = {'User3'}>} vPA*SUN_IH_EffortTime)+

sum({$<SUN_OwnerAccount = {'User4'}>} vPB*SUN_IH_EffortTime)+

sum({$<SUN_OwnerAccount = {'User5'}>} vMH*SUN_IH_EffortTime)+

sum({$<SUN_OwnerAccount = {'User6'}>} vDL*SUN_IH_EffortTime)

I'm hoping that you can tweak my set which would do it, but I'm happy to change how I achieve these results!

Kind Regards,
Dayna

Set Analysis to Include Selected Dimension

Tue, 08 Mar 2011 12:16:33 GMT

What if you took the variable out the Sum function?

i.e

sum({$<SUN_OwnerAccount = {'User1'}>} SUN_IH_EffortTime ) * vRB + ...

Set Analysis to Include Selected Dimension

Dayna — Tue, 08 Mar 2011 12:33:05 GMT

Hello Gareth,

Same again, doesn't change the values when I select one of the users...

Kind Regards,
Dayna

Set Analysis to Include Selected Dimension

Tue, 08 Mar 2011 12:40:44 GMT

The expression I suggested overides the selections ie User 1 is set etc.

What you should need in this case is =sum(SUN_IH_EffortTime) * vRB

Regards

Gareth

Set Analysis to Include Selected Dimension

Dayna — Tue, 08 Mar 2011 12:48:08 GMT

Hello Gareth,

vRB is applicable to only User1, User2 has a different variable assigned, so I dont want all users to be mutliplied by vRB, only User1 (hence the Set Analysis).

Kind Regards,
Dayna

Set Analysis to Include Selected Dimension

Tue, 08 Mar 2011 13:20:31 GMT

I am sure someone else may be able to explain this better but here goes:

The Expression which will not change regardless of your User selections is as follows:

sum({$<SUN_OwnerAccount = {'User1'}>} SUN_IH_EffortTime ) * vRB +

sum({$<SUN_OwnerAccount = {'User2'}>} SUN_IH_EffortTime ) * vHSJ +

sum({$<SUN_OwnerAccount = {'User5'}>} SUN_IH_EffortTime ) * vMH +

sum({$<SUN_OwnerAccount = {'User6'}>} SUN_IH_EffortTime ) * vDL .

There may be a better way out there but my only suggestion would be to try set users as variables and make selections using selection boxes. Sorry but further than this i beyond me at this stage...

;(

sum({$<SUN_OwnerAccount = {'User3'}>} SUN_IH_EffortTime ) * vPA +

sum({$<SUN_OwnerAccount = {'User4'}>} SUN_IH_EffortTime ) * vPB +