topic Re: "not" function in QlikView

"not" function

Fri, 03 Apr 2015 07:28:22 GMT

Hi all,

I'm trying to solve a question and I don't even know if it is possible to solve.

Example:

Table with Person and attribute

Person1 attribute A, B

Person2 attribute A,B,C

Person3 attribute B,C

Person4 attribute A,C

Person5 attribute A

I would like to have a sort of "not" function: when I decide "I want to remove alle the people with A attribute", remove all the people with A even if they have also another attribute.

I did a try with the And/Not function but when I use the not (colouring in red the A attribute) function only the person 5 is removed from the selection.

Any idea?

Thanks in advance

Diego

Re: "not" function

Peter_Cammaert — Fri, 03 Apr 2015 07:40:40 GMT

I have one (an idea): use a calculated dimension.

Best,

Peter

Re: "not" function

Fri, 03 Apr 2015 07:52:14 GMT

Not that easy... Sorry, I didn't say that it's just an example. I have hundreds of these situations and every "not" will effect on several sheets/graphs/tables.

Re: "not" function

vishsaggi — Fri, 03 Apr 2015 07:55:04 GMT

Hello Diego,

Can you send me the table structure of how your data looks and also you said you tried using AND/Not function with some coloring in red, where exactly you are using this.

Just wondering is this how your table should look like?? Below:

LOAD * Inline [

Person, Attribute

Person1, A

Person1, B

Person2, A

Person2, B

Person2, C

Person3, B

Person3, C........etc.

];

Re: "not" function

Peter_Cammaert — Fri, 03 Apr 2015 08:02:14 GMT

If it's a permanent exclusion, and you're not very eager to implement a solution 100 times, then why not throw out the data in your script?

Re: "not" function

Fri, 03 Apr 2015 08:03:56 GMT

The structure is pretty complicate. there are about 170 tables. What I'm using is (I'm still trying to stay simple):

Table "people"

-Name, Last Name, Gender a ,lot of other fields, reference to attribute table.

Table attribute

-Number (reference), description, reference to a sub-attribute

Table sub-attribute

-reference, description

I need to exclude a sub-attribute and this way exclude all the people if they have at least this attr (even if they have other sub attribute).

Tables are correctly linked, selections works fine.

Re: "not" function

Peter_Cammaert — Fri, 03 Apr 2015 08:04:48 GMT

An example that works. However, I wouldn't like to do this +100 times either... Is there a possibility to store the caluclated dimension in variables, and use a loop in your scirpt to calculate the expression for each different table?

Re: "not" function

Fri, 03 Apr 2015 08:05:17 GMT

Because the user need to have the possibility to decide when exclude and when not

Re: "not" function

Fri, 03 Apr 2015 13:58:07 GMT

Hi Diego,

You have the ability to insert a Set Analysis in the dimensions of the graph or tables that must follow this policy?
If you could, use the following set analaysis:

{$ <Attribute -= {'*A*'}>}

or
{$ <Attribute = {'*'} - {'*A*'}>}

This set analysis excludes any dimension that is connected to a attibute that contains A,

based on your example of data attributes in a single field.

Regards

Gennaro

Re: "not" function

Fri, 03 Apr 2015 14:05:33 GMT

Can't do this way, A attribute was just an example. I have tons of attribute, different tables, and I need to let final user to select or not every attribute...

Re: "not" function

Anonymous — Mon, 05 Sep 2016 12:07:05 GMT

please clarify your table

Person, Attribute A , Atttribute B

Person 1 , value , value

How does it look like , the first table is not structured clearly