Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
engr_farhanqadr
Creator
Creator

List Box not connecting with all sheet objects

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";

2 Replies
nizamsha
Specialist II
Specialist II

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

Not applicable

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