topic Re: Link between two tables in QlikView

Link between two tables

jeevays7 — Fri, 07 Apr 2017 10:29:26 GMT

Hi all,

I have a tables like below.

Name	Opening price	End price	Difference
A	10	20	Check
B	20	25	Ok
C	30	50	check

the above table has a difference column. it is showing as check if the difference (Opening and end price) is greater than 5.

so i need when i click any Check in the above table the link should go to the another table.

the linked table is below for the Name of "A".

Name	Opening price	Credit	End Price
A	10	10	20

so when i click the check in a first row it will trigger to the link table.

Please suggest any idea's....

Re: Link between two tables

jpar0511 — Fri, 07 Apr 2017 10:36:40 GMT

From what I can see:

Why don't you just link or join one table with the other table. After that you don't use "Check" as a result if the difference is out of limits but something like
'Credit: ' & Credit

to show the Credit Value?

Re: Link between two tables

jeevays7 — Fri, 07 Apr 2017 10:48:17 GMT

Hi Partikel,

First i need summary and then if i click it will go to the explanation table.

so i need this and i have use some calculations in front end to assign "check" or "OK" in difference column.

Re: Link between two tables

jeevays7 — Sat, 08 Apr 2017 09:24:57 GMT

Hi all,

anyone has any ideas about it??

Re: Link between two tables

Kushal_Chawda — Sat, 08 Apr 2017 16:54:25 GMT

Please elaborate more on your requirement.

What is the underlying data and what output you need?

Re: Link between two tables

sateeshkumar — Mon, 10 Apr 2017 07:16:10 GMT

Try once as below or share one sample doc.

First, link those two tables in data model. then, in straight table to use font format to to display in underline. Now Go to document properties->Triggers-> field level trigger on field->on select-> set variable.

if(Getpossiblecount(Dim1)=1 and getpossiblecount(dim2)=1, Var1)

in value give it as 1.

Create second table and provide conditional show if(Getpossiblecount(Dim1)=1 and getpossiblecount(dim2)=1 and Var1 =1.

So when user clicks on underline value it will trigger and display new table.