topic Re: AGGR Function in Dimension not displaying values in QlikView

AGGR Function in Dimension not displaying values

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: AGGR Function in Dimension not displaying values

sunny_talwar — Thu, 28 Apr 2016 12:28:51 GMT

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?

Re: AGGR Function in Dimension not displaying values

Anonymous — Thu, 28 Apr 2016 12:29:13 GMT

to give the other function in that like sum or count

Re: AGGR Function in Dimension not displaying values

MK_QSL — Thu, 28 Apr 2016 12:30:09 GMT

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

Re: AGGR Function in Dimension not displaying values

Thu, 28 Apr 2016 12:37:58 GMT

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?

Re: AGGR Function in Dimension not displaying values

MK_QSL — Thu, 28 Apr 2016 12:39:57 GMT

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

Re: AGGR Function in Dimension not displaying values

Thu, 28 Apr 2016 12:42:04 GMT

Please find enclosed the screenshot for listbox.

Thanks a lot

Re: AGGR Function in Dimension not displaying values

sunny_talwar — Thu, 28 Apr 2016 12:43:50 GMT

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

Re: AGGR Function in Dimension not displaying values

Thu, 28 Apr 2016 12:47:14 GMT

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

Re: AGGR Function in Dimension not displaying values

MK_QSL — Thu, 28 Apr 2016 13:04:13 GMT

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..

Re: AGGR Function in Dimension not displaying values

Thu, 28 Apr 2016 13:08:44 GMT

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

Re: AGGR Function in Dimension not displaying values

sunny_talwar — Thu, 28 Apr 2016 13:10:18 GMT

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?

Re: AGGR Function in Dimension not displaying values

MK_QSL — Thu, 28 Apr 2016 13:11:39 GMT

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..

Re: AGGR Function in Dimension not displaying values

engishfaque — Thu, 28 Apr 2016 14:58:47 GMT

Dear Sasi,

Kindly have a look into attached video.

Kind regards,

Ishfaque Ahmed

Re: AGGR Function in Dimension not displaying values

Thu, 28 Apr 2016 18:04:12 GMT

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.

Re: AGGR Function in Dimension not displaying values

engishfaque — Thu, 28 Apr 2016 18:52:24 GMT

Dear Sasi,

I would suggest you to share your App.

Kind regards,

Ishfaque Ahmed

Re: AGGR Function in Dimension not displaying values

Thu, 28 Apr 2016 20:43:07 GMT

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

Re: AGGR Function in Dimension not displaying values

Sat, 30 Apr 2016 11:35:07 GMT

Thanks All for your valued Response.

Uvarani - As you said the data is not correct.

Thanks,

Sasi