Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

laureadiaz
New Contributor II

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

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!

7 Replies
Employee
Employee

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

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
Honored Contributor

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

May be modify set analysis like this:

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

laureadiaz
New Contributor II

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

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

laureadiaz
New Contributor II

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

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
Valued Contributor

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

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
New Contributor II

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

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
Valued Contributor

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

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.

Community Browser