topic Re: How to stop a certain data value from show up? in QlikView

How to stop a certain data value from show up?

chiranjivdas — Thu, 24 Jan 2013 02:39:20 GMT

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,

Re: How to stop a certain data value from show up?

Thu, 24 Jan 2013 02:50:55 GMT

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