topic Re: Showing more dimension values than those selected in chart with set analysis in QlikView

Showing more dimension values than those selected in chart with set analysis

Tue, 17 Feb 2015 12:28:25 GMT

Hello,

I have a chart (pivot table) in which I'd like some of the dimensions to list values beyond those selected.

I tried using a calculated dimension with SA expression such as:

Aggr(Only({1}Field1),Field1)

to show all values, but I get only the selected values in Field1.

Could anyone help please?

Thanks!

-Michal

Re: Showing more dimension values than those selected in chart with set analysis

Anonymous — Tue, 17 Feb 2015 12:31:50 GMT

try

aggr(only({1<Field1=>}Field1),Field1)

Re: Showing more dimension values than those selected in chart with set analysis

tresB — Tue, 17 Feb 2015 12:39:07 GMT

Instead use Set in the expression of the chart, like:

Dim: Field1

Expression: Sum({1} Amount)

Re: Showing more dimension values than those selected in chart with set analysis

jonathandienst — Tue, 17 Feb 2015 12:45:55 GMT

Have you turned on Suppress Zeroes and Suppress Nulls? If these are on it is likely that the expressions are returning null for the non-selected Field1 values and are being suppressed.

Turn off the suppression or add a Field1 selection override to all the expressions in the chart.

HTH

Jonathan