Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

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
Valued Contributor II

Re: Link two tables with chart function

Hi,

in a sheet or graph

add a calculated dimension :

if(itemcode=item,itemcode)

and then you can access price in expression

regards

3 Replies
imhappiee
New Contributor III

Re: Link two tables with chart function

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
Contributor

Re: Link two tables with chart function

Hi,

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

ogautier62
Valued Contributor II

Re: Link two tables with chart function

Hi,

in a sheet or graph

add a calculated dimension :

if(itemcode=item,itemcode)

and then you can access price in expression

regards