Remove Field during data Load

[#1]

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

[Anonymous · Accepted solution]

Maybe add something like :

     where not [Measure] = 'Revenue'

[#3]

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);

[#4]

Load
Data,
Market,
Measure, 
Technology,
Region,
ShipDate,
  
ApplyMap('Portfolio_Mapping2',Technology,'') AS Part_Type

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

where Measure<>'Revenue' ;