Removing parts of a dimension?

[#1]

Quite new to Qlikview. I am using version 11. One of my dimensions is "Brands" which gives a list of the brands my company manages and I create reports but on occasion we no longer represent certain brands and rather than removing all the data from the excel docs the .qvds are drawing from, is there a way to put it into the script?

eg.

Brand A

Brand B

Brand C

Brand B we no longer manage so I would like it to no longer show up in my reports.

[Anonymous]

One way is put this in the "WHERE" clause on your load, something like this:

where Brand <> 'Brand B';

[MarcoWedel]

LOAD *
FROM Excelfile.xls (...)
Where not Brands like 'Brand B';

[Clever_Anjos]

LOAD * INLINE [
    Blacklist
    Brand B
    Brand Acme
];

LOAD *
from file.xlsx(...)
where not Exists(Brand,Blacklist)