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

[#2]

HI Manish,

I created two list boxes. One with AGGR([Adjustor/Adjustor Supervisor] ,[Adjustor/Adjustor Supervisor] ) not displaying values & other one displaying values.

Please find the screenshot in the above response

Thanks a lot

[sunny_talwar]

It seems nothing is available for selection. If this is true, then I wouldn't see anything anyway in the Aggr() list box. Can you clear out all selections and check if it is still not showing anything?

[MK_QSL]

I can see that for your current selection you have all value of

[Adjustor/Adjustor Supervisor] list box is grayed out. That means they are not available for the current selection.

Aggr([Adjustor/Adjustor Supervisor] ,[Adjustor/Adjustor Supervisor] ) will also give you no data as no value is available..so what's the issue?

Create a Text Box and Use below expression...

=COUNT([Adjustor/Adjustor Supervisor])

and let us know if you are getting any value or not..

[engishfaque]

Dear Sasi,

Kindly have a look into attached video.

Kind regards,

Ishfaque Ahmed

[#6]

Dear QV Experts,

I can able to see the values in a table, when i view it in TableViewer.

But In TableBox, i pulled the columns from the table only. i cant see any records.

Please find the screenshot below.

What might be the reason? It is surprising. Kindly advise.

[engishfaque]

Dear Sasi,

I would suggest you to share your App.

Kind regards,

Ishfaque Ahmed

[#8 · Accepted solution]

Hi Sasi,

1) Production environment QVD's and Test environment Qvd's having same data's?

2) Please check in Raw QVD contains the data (As per the selection's in your dashboard) or not?

3) section access has implemented in your application? if yes, Please check the section access tables (Qvd's) for both prod and Test environment are same or your name added in the prod environment?

Hope it will be helpful for you.

-Uva

[#9]

Thanks All for your valued Response.

Uvarani - As you said the data is not correct.

Thanks,

Sasi