topic Re: Remove Field during data Load in QlikView

Remove Field during data Load

Tue, 06 Oct 2015 09:58:02 GMT

Hi All,

It's been a while since I've worked on Qlikview and my memory is very rusty. I have a Dashboard that loads data from an Excel file. One of the columns in the file is called Measures and it contains Fields such as: Units, Region, Technology, Revenue. During my Load I want to NOT load the Revenue field (I don't want users of this Dashboard to have access to sensitive Revenue data).

Can you help me in how to exclude the Revenue Field from the load.

Load
Data,
Market,
Measure,
Technology,
Region,
ShipDate,

ApplyMap('Portfolio_Mapping2',Technology,'') AS Part_Type

FROM

[$(vSource_QVD_Folder) CUrrent.qvd](qvd);

Thanks for the help - the rustiness will go away soon

John

Re: Remove Field during data Load

Anonymous — Tue, 06 Oct 2015 10:01:39 GMT

Maybe add something like :

where not [Measure] = 'Revenue'

Re: Remove Field during data Load

Tue, 06 Oct 2015 10:16:37 GMT

thanks for the quick reply. I tried using this but it comes up as a syntax error. Do I place this code directly after the FROM section in the script?

FROM

[$(vSource_QVD_Folder) CUrrent.qvd](qvd);

Re: Remove Field during data Load

Tue, 06 Oct 2015 10:16:40 GMT

Load
Data,
Market,
Measure,
Technology,
Region,
ShipDate,

ApplyMap('Portfolio_Mapping2',Technology,'') AS Part_Type

FROM

[$(vSource_QVD_Folder) CUrrent.qvd](qvd)

where Measure<>'Revenue' ;