Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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