Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

chiranjivdas
New Contributor III

How to stop a certain data value from show up?

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

1 Solution

Accepted Solutions
Not applicable

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

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

1 Reply
Not applicable

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

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