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: 
wanyunyang
Creator III
Creator III

Link two tables with chart function

My table1 has field: item, table2 has fields: itemcode, price. In my chart, I want do have a table with item and price. So I need a function like: IF(item=itemcode, price).

Is it possible to do so? I don't want to link two tables in the script, just write chart functions.

1 Solution

Accepted Solutions
ogautier62
Specialist II
Specialist II

Hi,

in a sheet or graph

add a calculated dimension :

if(itemcode=item,itemcode)

and then you can access price in expression

regards

View solution in original post

3 Replies
imhappiee
Contributor III
Contributor III

Hi

Just rename your itemcode as item in the script in Table2 , It will automatically give you the desired result , you dont need to join the tables in specific.

Anand

wanyunyang
Creator III
Creator III
Author

Hi,

Thanks for replying, but I mean I don't want to change the script. Is there a way to write a function? 

ogautier62
Specialist II
Specialist II

Hi,

in a sheet or graph

add a calculated dimension :

if(itemcode=item,itemcode)

and then you can access price in expression

regards