Selection on Grey values in select box shows results

[#1]

Hi all,

I encountered a situation involving a selection box with multiple values and a corresponding Bar chart.

Some of the values in the selection box are white and other were grey, thus not relevant for current selections.

I tried to select one of the Grey values, and apparently my Bar chart was effected and different values were shown.

Maybe someone can correct me, but as I understood if a value is in Grey it is not related to the data (under current selections) and no values should be shown.

What can cause this issue that selection on grey values does effect the Data.

Thanks,

Boris

[lironbaram]

your basic assumption is right.

but when you select a gray value

what happens is that at least one of your former selections will be cleared

in order to display data relevant for your last selection

this is how qlikview works

[cfz]

Hi Boris,

In general you can select a value in grey (excluded values). What you do the is to perform a new selection. How this will affect the charts and other objects it will depend of the dimensions/expressions of the chart and specially in which state the object is.

If you can attach your QlikView document I can have a look and give you a more specific answer.

I hope it helps.

Carlos

[#4]

So basically is there any way to prevent this 'selection cancellation' upon a grey selection and force the user to make the right selections to make this value available?

[cfz · Accepted solution]

One way it would be to slect 'Hide Excluded' in the General tab of the Properties of the list box as in the attached example.

[#6]

Thanks!

[vijetas42]

Hi,

another way is to use expression in list box-> properties-> general tab where you select fields add expression as,

Aggr(fieldname, fieldname)

Regards,

Vijeta