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
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Measure Based on Lookup into another Dimension

Direct Discovery

Oracle DB

There are 2 dimensions "Product Store 1" and "Product Store 2" as below.

Both have same products but different IDs. Both the IDs exist in the FACT table.

Product Store 1

Product ID Store 1

Product Name Store 1

AApple
BBanana
CCarrot
DDill

Product Store 2

Product ID Store 2

Product Name Store 2

WApple
XBanana
YCarrot
ZDill

  

FACT Table

Product ID Store 1

Product ID Store 2

Sales

AW10
BX5
CY20
DZ60
BY5
CX30
AZ20
BY40
DX10
CZ90
AW80
BW30

Report Requirement

Report has"Product Store Name 1" in the row.
But the sales should be of "Product Store Name 2" i.e. Lookup the "Product Store Name 1" in Store 2 and get the sales

   

Report Output

Product Name Store 1

Sales(Product ID Store 2)

Comments

Apple120Sum of W's
Banana45Sum of X's
Carrot65Sum of Y's
Dill170Sum of Z's

Need help!!!

5 Replies
Gysbert_Wassenaar

See attached example

sillytricksdepartment‌


talk is cheap, supply exceeds demand
Not applicable
Author

Thank You... It works for QlikView.

Any thoughts on QlikSense?

Not applicable
Author

Hi.. Thanks for the example.

It is really helpful.

Was wondering if this can be done at report level?

Not applicable
Author

in Qlik Sense

Gysbert_Wassenaar

Use the same script.


talk is cheap, supply exceeds demand