Script to get at the Inline

[#1]

Needful to get Journal='IC','IG and class='SAS','AB''

Previously for single Journal='ES','EE' DONE LIKE THIS

TEMP:

Load * Inline

[

Key

ES

EE

  ];

LOAD Office,

     Cur,

     Manajor,

     Type,

     Number,

     Class,

     Journal,

     [Amount Me]

FROM

(ooxml, embedded labels, table is Sheet1)

where exists (Key,Journal );

DROP Table TEMP;

[ashfaq_haseeb · Accepted solution]

like this

LOAD Office, 
     Cur, 
     Manajor, 
     Type, 
     Number, 
     Class, 
     Journal, 
     [Amount Me]
FROM
[My Data Struggle.xlsx]
(ooxml, embedded labels, table is Sheet1)
where match(Journal,'IC','IG') and match(Class,'SAS','AB');

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

Can you close this thread?

Regards

ASHFAQ

[#4]

sure i forget to do so i will close this thread.Strugguling with the QlikView Requirement on hyperlink on measures through next level of drill down