topic Link in Two Tables in QlikView

Link in Two Tables

bharatkishore — Wed, 18 Apr 2012 13:59:37 GMT

Hello All,

In my application i have 3 sheets. In first i took an list box with "Lot No" and in second sheet i took an list box "IMM" and in third sheet i created an chart.

My problem is if i select values in first sheet list box i am getting the values fine. But when i am selecting the first sheet list box "Lot No" first value i am getting minimum value for "BCShotFlowIndexA" in third sheet chart is Min value is 329 and Max value is 386.

But in second sheet the min and max values for "BCShotFlowIndexA" are not changing. Please give a solution for this. I am attaching my application for your better understanding.

Regards,

R.Bharat Kishore

Link in Two Tables

Gabriel — Wed, 18 Apr 2012 14:57:53 GMT

Hi,

Is there a particular request for you to have the List Boxs separated?

1- I think there isn't key fields joining the 3 tables together, I would suggest you check the script, and follow fields names as there could be a slight differences in the naming of each fields meant to be the joining key that is not obvious.

2- Create the tables in one sheets test the relationships, if that works separate the tables if need be.

Hope that's helpful

Regards,

Gab

Link in Two Tables

bharatkishore — Thu, 19 Apr 2012 06:50:18 GMT

HI gabsus,

Thanks for the reply.No i don't have any particular request like that. We can do all in single sheet. Can you please help me how to do it. I want to get the link for those tables.

What condition i can use for it so that i can get the link between the tables.

Regards,

R. Bharat Kishore

Re: Link in Two Tables

Gabriel — Thu, 19 Apr 2012 08:49:50 GMT

Hi,

Can you check your script for any fields naming that is not consistent.

Altenatively send the file with the tables in Excel file.

Message was edited by: gabsus04