How to display only certain values in a table?

[#1]

Hello,

I am so new to this, and need your help.

This is my table

Cars	Country	Models
BMW	GER	12
TOYOTA	JPN	20
HONDA	JPN	18
NISSAN	JPN	15

I need to display information for just BMW and Toyota. How do I do that ?

Cars	Models
BMW	12
TOYOTA	20

I tried =if(match(Cars,'BMW', 'TOYOTA', ), Cars,'OTHER')

and added Expression sum(Models)

The problem with that one is that i don't want to display any other values but with my calculated dimension I get OTHER row. I don't want to show anything else.

Thanks a lot

[#2]

I solved it. I used "Suppress Value when Null", option in the table.

Thank you all for trying

[luciancotea]

Why would you recommend that?

[sunny_talwar]

Isn't the set analysis going to do this?

His dimensions adds 'OTHER' dimension, but no where does he mentions that he needs anything except those two, does he?

UPDATE: And may be this also

[sunny_talwar]

I still think you should use set analysis instead of using calculated dimension.

Dimension: Cars

Expression: =Sum({<Cars = {'BMW', 'TOYOTA'}>}  Models)

[luciancotea]

Set Analysis is not the answer to everything.

The main problem with it is that it breaks the basic rule of QlikView: click and view. You no longer see what your selection tells you to, but some rule hidden inside an expression. It's tricky and not transparent to the user.

Yes, it is powerfull. Thats one more reason to use it carefully.

[sunny_talwar]

Lucian‌ I completely agree with you, but I am just proposing a solution for what is being asked. I am not making things up from thin air my friend. I apologize if my proposed solution is not up to your expectations. But allowing for selection is possible through set analysis

=Sum({<Cars *= {'BMW', 'TOYOTA'}>}  Models)

I just think and have heard so many experts say that calculated dimensions are slow and that's the only reason I propose set analysis. If you can prove me otherwise, I would still think that set analysis can be a useful approach here

[luciancotea]

I am just pointing that your solution might create other issues. Yes, you solve one problem, but you have to think at the overall impact and user experience.

I don't have to prove you anything, do whatever you like. This message is mostly for all the begginers in QlikView that think that Set Analysis is a panaceum.

[sunny_talwar]

Your just getting aggressive for no reason. I am not an expert myself and looking for opportunities to learn new things. I think you might be totally right, but unless I see what issues might come up, how would I agree with what I am saying. I am sorry if I offend you. By no means I am looking to hurt anyone .

[sunny_talwar]

Attached is a sample where I have created both calculated dimension and set analysis, would you be able to suggest what might go wrong?

[sunny_talwar]

gwassenaar‌ , swuehl‌ would you guys be able to let me know if what I mentioned above is not consistent with what you guys think??