topic exclude values from a field in QlikView

exclude values from a field

Tue, 04 May 2010 16:05:41 GMT

Hello Together,

how can i exclude from beginning some values in Developer ?

Example:

I have a field with a, b, c, d values to click. However, i would like to choose only a, c values and want to exlude
b,d from selection.

I have a solution with the Publisher about the feature "reduction". But i need it in an Object or a Diagramm in Developer.
Have somebody an idea ?

Thank you very much!

Many greetings,
honour

exclude values from a field

Tue, 04 May 2010 16:46:53 GMT

i would try the following options:

1. Add a condition in your load script to separate those 2 options from those four values, for example:

if(Field='A', 'Option 1', if(Field='B', 'Option 2', if(Field='C', 'Option 1', if(Field='D', 'Option 2')))) as Option

and add 'Option' as a filter in a listbox, multibox.

2 .I would create a table for this purpose and link it to your table with the a,b,c,d, for example:

Filter:

Load * Inline

[Value, Option

A, OPTION 1

C, OPTION 1

B, OPTION 2

D, OPTION 2

]

and add 'Option' as a filter in a listbox, multibox.

exclude values from a field

Tue, 04 May 2010 17:10:55 GMT

There are two possible solutions depending on what you actually want to accomplish. One you can filter the data during the Load using a Where clause to exclude the unwanted data, or you could use Set Analysis on the aggregate expressions. A straight table chart that suppresses 0 values should only shows rows a & b in the below example, assuming you have [dimension field] as the only dimension on the chart.

Sum({$<[dimension field]={"a,b"}>} [measure field])

exclude values from a field

Tue, 04 May 2010 17:28:22 GMT

Hi dragonauta,

I thank for your help.

I have selected the alternative 1.
At the end I have the expected values with mine desired values.

What do you mean with the filter?
. add 'option' as a filter in a listbox, multibox.

Because I have now the values an want to select these values too.
What I have to do that make there are clicked?

Many thanks over again. Sorry for my english

Many greetings,
honour

exclude values from a field

Tue, 04 May 2010 17:46:25 GMT

Hi,

your 'where' did help me. Thank you very mutch too