Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

AGGR Function in Dimension not displaying values

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

View solution in original post

17 Replies
Highlighted

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?

Highlighted
Creator III
Creator III

to give the other function in that like sum or count

Highlighted
MVP
MVP

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

Highlighted
Not applicable

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. !Sheet.jpg

What might be the reason?

Highlighted
MVP
MVP

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

Highlighted
Not applicable

Please find enclosed the screenshot for listbox.

Thanks a lotListBox1.jpg

Highlighted

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

Highlighted
Not applicable

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.

ListBox.jpg

Thanks a lot

Highlighted
MVP
MVP

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