Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
andriesb
Contributor

Advance filtering via GUI: exclude all possible values

I would like to filter all items where a name does NOT exist in group 10.

NameGroupBoolean
John10
John20
John30
Jack20
Jack30
Rob20

When loading this 'source' document as-is, it would result in 6 records.

I would like to filter all result for group 20 and 30 , but exclude results that also exist in group 10. If name = 10, always skip this name from result.

The result should only contain Jack and Rob : John does exist in group 10 and should not be added.

If I filter on group 20,30 , 'John' would still show up as he exist in groups 20 and 30. Could this be done via the GUI ?

I know I could add advanced filtering via the Ctrl+shift+ F, but only on one column-value. Would this be a solution? My final result should also depend on some other boolean values.


2 Replies
jsn
Honored Contributor

Re: Advance filtering via GUI: exclude all possible values

Well..

You could use something like this:

=aggr(if(index(Concat(Group,';'), '10')=0,Name), Name)

However, it looks for every instance of 10 so if you have a group called 110 it would filter out that name too

(you can cirumvent this by concatenating start and end characters to the Group field in the Concat() function.)

andriesb
Contributor

Re: Advance filtering via GUI: exclude all possible values

My new attempt was to add a chart and within that chart use a calculated column (min (Group) ) . This will for each name show if a name is in an group 10  (from my example) Only john is in group '10' . by selection 'the rest' i have my query result....

In my example this 10 could be extracted because it was the lowest; in other cases your example would do Johannes.

I did find the usefull informaion via your reply on the aggr function via http://community.qlik.com/message/70711#70711


Difficult solution to eliminate all accurances of a name if a name is 'In an group' .