Selecting part of a graph to add to current selections for further QV analysis

[laureadiaz]

Hi,

   I have often been able to select, for example, a bar on a graph, and then that will be part of my current selections for other QV tabs, graphs etc. This is not happening on a "-" bar I have in a graph, any tips on selecting the null bar to add it to the current selections to see other QV analysis on it?

Thanks!

[Lisa_P]

This is typically when you have null values in relation to your dimensions, so you can't choose that from your chart by selecting bars. 

[balabhaskarqlik]

May be modify set analysis like this:

sum(DISTINCT {<column_A={'>0'}> + <column_B={' '}>} quantity)

[laureadiaz]

I'm not sure exactly what you are attempting, are you trying to make it not zero by adding another column to it?

[laureadiaz]

I figured out a solution.

Create a List Box, under caption tab they have a select all "special icon". Make the field on the general tab an expression with an if statement that gives the cutoff you want....

[timpoismans]

As Null values aren't data, but values of a dimension where you are missing data, you can't select them in a chart.

The only thing you could do is replace the null values in your dimension in the script so you are able to select on it in the charts.

[laureadiaz]

I think this is why my workaround is helping the List Box is using an expression, and I put an if statement that is the expression is 0, list the field. Then I can select all via the "special icon" on the top right.

[timpoismans]

While this does work, it's better to catch these things in the script and solve them there.

In case you want to select on this "Null-dimension" more than once, you'd have to write the expression multiple times. Catching the Null-values in the script and replacing it with something else ("Not defined" or anything, really) you can easily use it in charts, use it in expressions or set analysis, ...

Just my two cents though.