topic Show fields based on exists condition in QlikView

Show fields based on exists condition

Tue, 25 Oct 2011 10:57:22 GMT

Hi,

I am attempting to create a table in which a user will appear but only if certain values do not exist against the users ID. In total there are 4 values that I want to make sure don't exist against the user

I have tried using if(not exists(STATUS, 'ACTIVE') and if(not exists(STATUS, 'REACTIVATED'), USER_ID), but my table shows nothing. I presume that I am writing this out the wrong way.

Can anyone please help with this?

Thanks

Re: Show fields based on exists condition

RSvebeck — Tue, 25 Oct 2011 11:15:10 GMT

Hi.

Do you mean like this (see attached)

//Robert Svebeck

Show fields based on exists condition

Tue, 25 Oct 2011 11:31:03 GMT

Hi Robert,

Something similiar to that. For example:

Say User A - contained Apples and User A also contained Bananas. Whereas User B only had apples.

I want to show the Users that ONLY have Apples.

So it would be something like if( not exists, 'Bananas', UserID). So in my table it would only show User B.

From your example, I believe it would show User A and User B.

Re: Show fields based on exists condition

RSvebeck — Wed, 26 Oct 2011 10:34:57 GMT

It is possible to solve this with "count".

First you count total number of records for the dimension, and then count the number of records with apples for the dimension.

-> Then you will know if the data contains only apples by subtracting the differens in count.

But I seriously doubt that this is the "best solution".

It would be very interesting if someone can provide a better solition. See attached simplified example of my count solution...

// Robert Svebeck