Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ramp1985
Contributor II
Contributor II

Vlookup

Hi Guys.

Looking to make an expression to handle a lookup or similar.

I only have front-end access.

To keep it simple, I have these dimensions:

[SalesName]

[ResponsibleName]

Meassures:

Items sold

Price

In a table I have [SalesName] as the only dimension and then multiple Expressions showing performance from that [SalesName].

Sometimes SalesName and ResponsibleName is not the same.

What I now would like is to make an Expression in the same table (and keeping [SalesName] as the only Dimension), looking up the [SalesName] in the [ResposibleName] Dimension and then summing up the sales? (Also including the sales, where the SalesName is different, but ResponsibleName is equal.)

See example. 

How to? 🙂

Labels (3)
2 Replies
MayilVahanan

Hi @ramp1985 

May be , try like below

=Sum({<SalesName= p(ResponsibleName)>}Sales)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
ramp1985
Contributor II
Contributor II
Author

Thanks!. But seems like its still only takes the once where the SalesName also still is the same?

- Is it possible to find the equal ResponsibleName and sum the sales no matter what the SalesName is?

Thanks