List Box not connecting with all sheet objects

engr_farhanqadr — Fri, 28 Jun 2013 09:55:13 GMT

Dear All,

please help me out.

I have a problem at my dashboard(submitted business), a list box named Agent code at top left corner is not connecting with all sheet objects.

Please identify what am I doing wrong at script.

Attached is the screen shots.

Below is table script :

[connection string]

LAAG_AGENT:

LOAD

"AAG_AGCODE" as AgentCode,

"AAG_NAME" as AgentName,

"PCL_LOCATCODE" as Branch,

"AAG_AGCODE";

SQL SELECT AAG_AGCODE,

AAG_NAME,PCL_LOCATCODE,AAG_AGCODE

FROM "FQADRI"."LAAG_AGENT";

PCL_COMPLOCATION:

LOAD

"PCL_LOCATCODE" as Branch,

"PCL_LOCATDESC",

"PCL_BRANCHACTIVE";

SQL SELECT PCL_LOCATCODE,

PCL_LOCATDESC,

PCL_BRANCHACTIVE FROM

"ASIF_IQBAL"."PCL_COMPLOCATION";

LMMI_MIS_FINAL:

LOAD

ISSUED,

SUBMITTED,

"POLICYNO",

"MMI_TRANTYPE",

"PRODUCT",

"AAG_AGCODE" AS AgentCode,

"AGENT_NAME",

"SC_CODE",

"SC_NAME",

"EBDM_CODE",

"EBDM_NAME",

"UM_CODE",

"UM_NAME",

"ABM_CODE",

"ABM_NAME",

"BM_CODE",

"BM_NAME",

"SBM_CODE",

"SBM_NAME",

"GM_CODE",

"GM_NAME",

"RM_CODE",

"RM_NAME",

"SD_CODE",

"SD_NAME",

"TILL_DATE" as Date;

SQL SELECT *

FROM "ASIF_IQBAL"."LMMI_MIS_FINAL";

[ connection string ]

LAAG_AGENT:

LOAD "AAG_AGCODE" as AgentCode,

"CDG_DESIGCODE";

SQL SELECT "AAG_AGCODE",

"CDG_DESIGCODE"

FROM ILASSNAP."LAAG_AGENT";

LCDG_DESIGNATION:

LOAD "CDG_DESIGCODE",

"CDG_DESCRIPTION",

"CDG_SHORT";

SQL SELECT *

FROM ILASSNAP."LCDG_DESIGNATION";

Re: List Box not connecting with all sheet objects

nizamsha — Fri, 28 Jun 2013 10:02:38 GMT

if list box is displaying in one sheet mean surely it will display in all sheet ..right click and select the select fields. see in that weather the listbox is added or not ..if its added mean it might me hidded some where in our sheet object check that

Re: List Box not connecting with all sheet objects

Fri, 28 Jun 2013 10:21:36 GMT

Check out in the settings>general, maybe another alternative state is assigned to this list box.

topic Re: List Box not connecting with all sheet objects in QlikView

List Box not connecting with all sheet objects

Re: List Box not connecting with all sheet objects

Re: List Box not connecting with all sheet objects