Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

Straight Table Dimension problem

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

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

View solution in original post

10 Replies
Anonymous
Not applicable

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?

adiarnon
Creator III
Creator III
Author

hi,

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

Not applicable

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

maleksafa
Specialist
Specialist

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

adiarnon
Creator III
Creator III
Author

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...

adiarnon
Creator III
Creator III
Author

?

Anonymous
Not applicable

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?

adiarnon
Creator III
Creator III
Author

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

tresesco
MVP
MVP

Try like:

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