topic Ignore Listbox selections for a single Item on a sheet in QlikView

Ignore Listbox selections for a single Item on a sheet

Fri, 19 Nov 2010 17:23:20 GMT

Hi all,

I am trying to build a bar chart with two bars(expressions) where one expression reacts to all listbox selections and the other bar only reacts to some of the slections. For example I want both expressions to react to the YEAR selection, But I only want the second expression to react to the BUSINESS UNITListbox.

The Dimensions are YEAR and BUSINESS UNIT and PRODUCT

Both Expressions are :

COUNT(FIELDA)

My other option is to build Two charts on the same sheet side by side but I run into the same problem of having one react to LISTBOX selections and the other to ignore the BUSINESS UNIT selections.

Ignore Listbox selections for a single Item on a sheet

john_duffy — Fri, 19 Nov 2010 18:03:10 GMT

Hello.

You can use set analysis to accomplish this. Basically, your first expresson would use a set to ignore the selection for BUSINESS UNIT.

Something like Count ({$<[BUSINESS UNIT] = {"*"}>} FieldA). Note: Syntax not verified.

Let me know if this helps.

John.

Ignore Listbox selections for a single Item on a sheet

Fri, 19 Nov 2010 21:41:59 GMT

John,

Thanks . that worked perfectly !

Mike

Ignore Listbox selections for a single Item on a sheet

johnw — Fri, 19 Nov 2010 22:56:22 GMT

Simpler syntax just so you know:

count({<[BUSINESS UNIT]=>} FieldA)

The dollar sign is optional, and I prefer to exclude it since dollar signs are also used for dollar sign expansion and for parameters. And using = says to ignore the selections, which gives the same result as ={"*"}, which says to search for and "select" all values.

Ignore Listbox selections for a single Item on a sheet

john_duffy — Mon, 22 Nov 2010 17:22:12 GMT

Thanks for the tip John. Your syntax is much cleaner.

John.

Ignore Listbox selections for a single Item on a sheet

Fri, 13 May 2011 01:26:42 GMT

How would you alter above expression to ignore more than one list boxes selections. For exaple I already have ignore one selection (express) in this expression below.

=min({< sub_metrics = {'same day'},branch_flag ={'0'},express=>}target)

Now I also want to ignore Month dimension in the expression above. How would I change this to ignore month too along with express dimension?

Thanks in advance for any help.

Amey

Ignore Listbox selections for a single Item on a sheet

Thu, 01 Mar 2012 20:45:11 GMT

To ignore more than one selection, the syntax would look like this:

count({<Field1=,Field2=,Field3=>} FieldA)