AGGR Function in Dimension not displaying values

[#1]

Dear QV Expert,

In the dashboard, the listbox created with Expression for even normal columns.

For Example,

[Adjustor/Adjustor Supervisor] column, they write in an expression as

AGGR([Adjustor/Adjustor Supervisor],[Adjustor/Adjustor Supervisor]).

But it is working fine in Testing Environment.

When they move the same changes to Production Environment not displaying.

When i try inserting a listbox using the [Adjustor/Adjustor Supervisor] column, the values are displayed.

What might be the reason? Can anyone suggest me on this.

Please find enclosed the screenshots attached.

Thanks,

Sasi

[sunny_talwar]

What is the reason for using Aggr() to create the list box? You want to hide all those values not selected in the list box?

[Anonymous]

to give the other function in that like sum or count

[MK_QSL]

Can you check nothing is selected ? try using Current Selection Box..

[#5]

Except Client Listbox, No other list boxes or charts are loaded.

The same qvd, when i load in test environment it is working fine.

The qvw developed by the freshers & the last moment we intervened. !

What might be the reason?

[MK_QSL]

Can you also show list box for [Adjustor/Adjustor Supervisor] in the above screenshot?

[#7]

Please find enclosed the screenshot for listbox.

Thanks a lot

[sunny_talwar]

Can you add two list boxes one with this calculation and another one with the field name (keep the same selections)

UPDATE: Trying to see if there is anything to select in Adjustor field once you have selections made

[#9]

Hi Sunny,

Then the field name is displaying. The screenshot below, the left one is the Field Name, the right one just a - there.

But question is how it was working in Dev Environments. As this dashboard already deployed to Production we need to justify.

Thanks a lot

[MK_QSL]

Sasi Kumar... Can you please create two different list box...

One with AGGR([Adjustor/Adjustor Supervisor] ,[Adjustor/Adjustor Supervisor] )

and 2nd with [Adjustor/Adjustor Supervisor]  only.

We need to see what value is available for 2nd List box..