Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
zakpullen
Contributor III
Contributor III

Expression to return value of a single dimension item in a seperate column

Hi,

I need a column in a straight table that shows the expression value of one of the dimension items. This will be used as a comparator.

For example, I would like the Company score to appear in the Company column against each Unit (not worried about Company rows as present). I've been playing around with different set analysis options, but just can't get it. The Score column is just a basic sum.

3MAR2020.JPG

Thank you.

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

May be try this

Sum(TOTAL <DIM2> {<DIM1 = {'Company'}>} Score)

 

View solution in original post

2 Replies
sunny_talwar

May be try this

Sum(TOTAL <DIM2> {<DIM1 = {'Company'}>} Score)

 

View solution in original post

zakpullen
Contributor III
Contributor III
Author

Perfect!

 

Thanks as always.