topic Re: Script to get at the Inline in QlikView

Script to get at the Inline

Wed, 10 Sep 2014 21:21:33 GMT

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

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

TEMP:

Load * Inline

[

Key

];

LOAD Office,

Cur,

Manajor,

Type,

Number,

Class,

Journal,

[Amount Me]

FROM

(ooxml, embedded labels, table is Sheet1)

where exists (Key,Journal );

DROP Table TEMP;

Re: Script to get at the Inline

ashfaq_haseeb — Thu, 11 Sep 2014 12:42:37 GMT

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

Re: Script to get at the Inline

ashfaq_haseeb — Tue, 16 Sep 2014 10:50:03 GMT

Hi,

Can you close this thread?

Regards

ASHFAQ

Re: Script to get at the Inline

Tue, 16 Sep 2014 11:30:31 GMT

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