Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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])
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
Hi,
your 'where' did help me. Thank you very mutch too