Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ramp1985
Contributor
Contributor

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
ramp1985
Contributor
Contributor
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