topic Re: Making relation internally over two tables in QlikView

Making relation internally over two tables

Tue, 21 Jan 2014 09:49:43 GMT

Hello ,

i have a requirement to select the item from one table , it should make selection automatically on the same item existing in the another table on the same sheet.

I am describing my example here please find this

I have two table objects on sheet,

This is my First table

Table 1

Time

Temp

sec

This is my Second table

Table 2

Time

Percentage

Lots

Sec

I need to get the results as if i choose Time from "Table 1", automatically Time item in the "Table 2" should on select mode.

here Table1 and Table2 both are not having relationship over them.

Can anybody suggest me on this.

Thank you

Regards

Charitha.

Re: Making relation internally over two tables

alexandros17 — Tue, 21 Jan 2014 09:53:35 GMT

If you load data as you have written all fields are connected by the field Time that is if you select a Time all the fields in both tables that match the selected time will be returned, as you need.

You must pay attention to the time format

Hope this helps

Re: Making relation internally over two tables

Tue, 21 Jan 2014 11:12:32 GMT

i got the result by loading each column in separate manner.