topic Fetching values from Island table in QlikView

Fetching values from Island table

Anonymous — Sat, 22 Nov 2014 21:29:21 GMT

Hi All

Can anyone help me how to fetch the values from island table

TableA

LOB_ID
SHEET_ID
DIV_ID
LINE_NO
PROJ_BAL

TableB

iLOB_ID
iSHEET_ID
iDIV_ID
iLINE_NO
iOP_BAL

Req is

SHEET_ID LOB_ID LINE_NO iOP_BAL PROJ_BAL

How do I match columns (1,2, 3 & 4) from TableA with TableB and get iOP_BAL without join please ?

Thanks in advance

Re: Fetching values from Island table

Anonymous — Sat, 22 Nov 2014 21:36:09 GMT

Here DIV_ID is list box, so result shoud be dynamic, if DIV_ID is not selected than Sum(iOP_BAL) for all DIV_ID, otherwise based on selected DIV_ID.

Again there is no join

Thanks again

Re: Fetching values from Island table

stevedark — Sat, 22 Nov 2014 22:02:13 GMT

Hi Satish,

What you want to do is have the tables 'associate' in the data model - rather than do a join. The difference is that join's are enforced at load time whereas associations only come into play at the front end. Simply rename the fields you want to associate so that they are exactly (including case) the same in both tables.

You can lookup values in the front end from non associated tables (this is often used for FX rates and Translations) but generally it is best to let the associations do the work for you.

Steve