topic Re: How to displaying only certain values in the table? in QlikView

How to display only certain values in a table?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to displaying only certain values in the table?

arulsettu — Fri, 18 Mar 2016 10:34:25 GMT

try this

if(match(Cars,'BMW', 'TOYOTA' ), Cars)

Re: How to displaying only certain values in the table?

sunny_talwar — Fri, 18 Mar 2016 10:37:28 GMT

I would recommend using set analysis:

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

Re: How to displaying only certain values in the table?

tresB — Fri, 18 Mar 2016 10:38:43 GMT

Try removing an extra comma, like:

if(match(Cars,'BMW', 'TOYOTA'), Cars,'OTHER')

Re: How to displaying only certain values in the table?

Chanty4u — Fri, 18 Mar 2016 10:39:17 GMT

try this

if(match(crs,'bmw','toyota'),cars)

Re: How to display only certain values in a table?

Fri, 18 Mar 2016 14:22:09 GMT

It looks like your calculated dimension has a comma after 'TOYOTA'. Can you please erase that and try?

Re: How to display only certain values in a table?

Fri, 18 Mar 2016 15:08:28 GMT

This did not work and produced the following error:

//Error in calculated dimension

Re: How to display only certain values in a table?

Fri, 18 Mar 2016 15:11:01 GMT

This produces the following table. Instead of other, it creates "-" sign. I need to get rid of -/33 result.

Cars	Models
BMW	12
TOYOTA	20
-	33

Re: How to display only certain values in a table?

Fri, 18 Mar 2016 15:11:41 GMT

I need results without "OTHER"

Re: How to display only certain values in a table?

Fri, 18 Mar 2016 15:13:41 GMT

This produces the following table. Instead of other, it creates "-" sign. I need to get rid of -/33 result.

Cars	Models
BMW	12
TOYOTA	20
-	33

Re: How to display only certain values in a table?

Fri, 18 Mar 2016 15:15:17 GMT

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

Thank you all for trying

Re: How to display only certain values in a table?

luciancotea — Fri, 18 Mar 2016 15:28:01 GMT

Why would you recommend that?

Re: How to display only certain values in a table?

sunny_talwar — Fri, 18 Mar 2016 15:35:22 GMT

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

Re: How to display only certain values in a table?

sunny_talwar — Fri, 18 Mar 2016 15:42:37 GMT

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

Dimension: Cars

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

Re: How to display only certain values in a table?

luciancotea — Fri, 18 Mar 2016 15:53:52 GMT

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.

Re: How to display only certain values in a table?

sunny_talwar — Fri, 18 Mar 2016 15:57:49 GMT

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

Re: How to display only certain values in a table?

luciancotea — Fri, 18 Mar 2016 16:09:09 GMT

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.

Re: How to display only certain values in a table?

sunny_talwar — Fri, 18 Mar 2016 16:11:50 GMT

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 .

Re: How to display only certain values in a table?

sunny_talwar — Fri, 18 Mar 2016 16:20:59 GMT

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

Re: How to display only certain values in a table?

sunny_talwar — Fri, 18 Mar 2016 16:23:46 GMT

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