topic Filter in the expression in QlikView

Filter in the expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a set of linked dimensions, two of which are "Project" and "Type". I would like to create a table in Qlik Sense Desktop, where I'd like only the subset of projects which are of type "X". As I need that permanently, an not through a filter, there should be a way to set it. I thought there should be a way to do with with an expression but I wasn't able to find how.

Ivo

Re: Filter in the expression

swuehl — Wed, 14 Sep 2016 17:17:52 GMT

Try a dimensional master item like

=If(Type = 'X', Project)

Re: Filter in the expression

Anonymous — Thu, 15 Sep 2016 15:41:11 GMT

Great! Thanks.

And now I have in addition the following similar case:

Service, ProviderOfService, SimilarService, ProviderOfSimilarService

I would like all SimilarService of a Service, for which ProviderOfSimilarService != ProviderOfService

What would be the right syntax for that? So far, whatever I can think of, gives error, and I can't find a solution in the documentation.

I was able to achieve something in a very clumsy way:

if([ProviderOfSimilarService]=[ProviderOfService], Null() ,[SimilarService]), and then ignore null values but I hope there is more elegant solution.

Thanks in advance!