Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Karl_Hart
Creator
Creator

Excluding Dimensions that meet criteria

All,

I'm struggling to find out how to achieve the following:-

I have a list of properties that have had some work done on them:

Property        Project

Property 1:     New Roof

Property 1:     New Kitchen

Property 1:     New Bathroom

Property 2:     New Roof

Property 3:     New Kitchen

Property 3:     New Bathroom

I want a report that excludes any property that has had a New Roof.

So in this example, I would only want to see Property 3.

When I do set analysis, I can only get it to exclude the Project of "New Roof", i.e. I get the following table:-

Property        Project

Property 1:     New Kitchen

Property 1:     New Bathroom

Property 3:     New Kitchen

Property 3:     New Bathroom

How can I get it to exclude it if it has that Project code attached to it? i.e. I want to see

Property        Project

Property 3:     New Kitchen

Property 3:     New Bathroom

Many thanks.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use E(), something like:

sum( {$<Property= E({1<Project={‘New Roof’}>})>} Sales )

View solution in original post

2 Replies
tresesco
MVP
MVP

Use E(), something like:

sum( {$<Property= E({1<Project={‘New Roof’}>})>} Sales )

Karl_Hart
Creator
Creator
Author

Thanks a lot Tresesco