How to stop a certain data value from show up?

[chiranjivdas]

I have data for Company and Sales $$. Under Company, the values are Ford, GM, Toyota, Honda, Kia and under Sales I have $$ amounts. I want to pull everything in the Qlikview report except Kia and the $$ values associated with it. How can I create such a condition and where? Is it in Edit Script under File?

Thanks,

CD

[#2 · Accepted solution]

You should be able to add a condition at the end of the load:

LOAD

Company,

Amount

FROM xyz

WHERE Company <> 'Kia';

You could also exclude in your report using set analysis. For instance:

sum({<Company -= {'Kia'}>}Amount)

Hope that helps.

Best,

Matt