Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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