Filter in the expression

[Anonymous]

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

[swuehl · Accepted solution]

Try a dimensional master item like

=If(Type = 'X', Project)

[Anonymous]

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!