topic Re: select excluded in a straight table in QlikView

select excluded in a straight table

Thu, 23 Oct 2014 14:44:03 GMT

Hi all,

I have a problem.

I have a straight table with a field named Letter that has the values A,B,C,D.

Letter Number

A 2

B 4

C 3

D 7

In my straight table I want to view excluded values when I make a selection on the field, for example I select the value A. I can use a document trigger: in the section 'field event trigger' I choose the field and I create an action 'on select' with 'select excluded'. In this way I see in my table all field values without A, for example B,C,D.

If I make another selection on my field, for example B, the trigger shows me the values A,C,D.

I don't want this result, but I want that the second selection remembers that I have excluded A previously.

I have attached a file with another example of what I want to do.

Re: select excluded in a straight table

JonnyPoole — Thu, 23 Oct 2014 15:14:26 GMT

You can use SET ANALYSIS to do the context in a chart or text box expression (or multiple).

The following will show the non-selected values for Region in the table when a selection(s) is made on Region

Re: select excluded in a straight table

stigchel — Thu, 23 Oct 2014 15:14:29 GMT

See attached working example

Re: select excluded in a straight table

stigchel — Thu, 23 Oct 2014 15:16:45 GMT

Instead of selecting the excluded I update (add the new value to any already existing) a variable with every selection you make in Letter. Then in the set analysis of the expression I select all values of letter minus the contents of the variable

Re: select excluded in a straight table

Thu, 23 Oct 2014 15:34:59 GMT

It's what i want!

Thank You!

Re: select excluded in a straight table

stigchel — Thu, 23 Oct 2014 15:36:31 GMT

You're welcome

Re: select excluded in a straight table

Thu, 23 Oct 2014 16:02:14 GMT

I have tried the solution but doesn't work. In my table number values are calculated between a fuction: for example count(Letter)

When I try your example with =Only({<Letter={'*'}-{$(=vSel)}>} count(Number)), it doesn't work.

Re: select excluded in a straight table

stigchel — Thu, 23 Oct 2014 16:09:55 GMT

The solution is simple, instead of Only use the Count, so:

=Count({<Letter={'*'}-{$(=vSel)}>} Number)

The Set expression will work in any function that takes set analysis

Re: select excluded in a straight table

Fri, 24 Oct 2014 07:04:19 GMT

Thank you! Now it works!