7 Replies Latest reply: Sep 6, 2018 12:39 PM by vamsee duggirala RSS

    extracting the master data after using an intersection of master data with smaller data

    Mallika Mhapankar

      I have a table called tableone to which I had inner joined an external excel sheet because I needed only the intersection of the two data sets for one kind of analyses using the code-

       

      inner Join(tableone)

      LOAD

          PROD,

          PC

      FROM [lib://AttachedFiles/New file v4.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      Now for another analyses, I need to make a bar chart using data from tableone wholly- not its intersection with any other dataset. I know I can use qualify or resident load but not sure how to go about it. Could someone help me with the code for this please? And would I need to use any filters to tell qlik that the whole table tableone has to be taken?


      Thanks in advance