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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is way to stop association between the list boxes ?

Hi

I am new to Qlikview , I would like to know is there is any way by which the association between the two list boxes may be stopped. I would like to have a stable graph for a list box. Can some one help me?

1 Reply
Not applicable
Author

hi

since our qlikview work on AQL(assocition query language).

now to stop association between the list boxes, we use NOCONCATENATE or allias.

example-

    

LOAD A,

     B,

     C

FROM

(ooxml, embedded labels, table is Sheet1);

😧

NoConcatenate

LOAD A AS A1, 

     B AS B1,

     D,

     F

FROM

(ooxml, embedded labels, table is Sheet2);

************************************************************

second way to stop the assocition--

we change the allias-

such as

load      A, B, C

               FROM TABLE1

      load      A as a1,

                     B as b1,

                     D,

                         F

               FROM TABLE2