topic Re: Straight Table Dimension problem in QlikView

Straight Table Dimension problem

adiarnon — Wed, 27 Aug 2014 08:44:46 GMT

hi,

i have a straight table

my dimension is -resource name

my expresion -sum({<project name=>}effort_hours)

my problem - when im choosing in a list box a project name i want to see only the resource name that taking part of this project,

but i see all of my resources becouse of the expresion.

what should i do to see only the resources that taking part of the project?

adi

Re: Straight Table Dimension problem

Anonymous — Wed, 27 Aug 2014 08:49:44 GMT

in your expression you define that you want to see all sums regardless of selection of project names

So if you only use sum(effort_hours) you will only see the sum for the seletced projects.

But maybe you have another intention?

Re: Straight Table Dimension problem

adiarnon — Wed, 27 Aug 2014 08:57:26 GMT

hi,

tnx but i need to keep the expresion like it is.

Re: Straight Table Dimension problem

Wed, 27 Aug 2014 09:01:22 GMT

Hi adi,

if i understand u r requirement properly,

i am suggesting u the expression to use as

Sum([Effective Hours])

and dimension as Resource Name

Re: Straight Table Dimension problem

maleksafa — Wed, 27 Aug 2014 09:03:30 GMT

if you want to see only the resources related to your selection you should change the expression to sum(effort_hours)

Re: Straight Table Dimension problem

adiarnon — Wed, 27 Aug 2014 10:21:07 GMT

i want to see only the resources related to my selection BUT i want to see their effort hours in ALL of the project not just their their effort hours of the selected one...

Re: Straight Table Dimension problem

adiarnon — Wed, 27 Aug 2014 10:52:59 GMT

Re: Straight Table Dimension problem

Anonymous — Wed, 27 Aug 2014 10:59:44 GMT

if you only want to see the overall effort (despite the selection)

you can use: sum(total <project name> {<project name=>}effort_hours)

but the user will see a result which does not belong to his selections (means: user selected a project

and gets the overall effort).

But maybe I misunderstood your requirements?

Re: Straight Table Dimension problem

adiarnon — Wed, 27 Aug 2014 11:06:25 GMT

yes, the expresion is fine but my problem is -

i want that the table will show only rows of resources that related to the project.

and now i see all of my resources.

hope its clear

Re: Straight Table Dimension problem

tresB — Wed, 27 Aug 2014 11:08:37 GMT

Try like:

Sum( {1<Resource=p({<[project name]=p([project name])>})>}effort_hours)

Re: Straight Table Dimension problem

Wed, 27 Aug 2014 11:22:43 GMT

Hi Adi, Create one more field in Script that is alias of 'project name' Then use alias field in expression. 'project name' in list box.