Suppress Zero values not working in Production environment

[Anonymous]

Dear Members,

I have a straight table chart with one dimension and few expressions.

On the Dimension I have checked Suppress when value is Null and On Presentation tab I have checked both Suppress Zero values and Suppress Missing.  My dashboards is working fine both in Desktop and Access Point both in Development and Test environments of Access Point. However when i migrate this dashboards to Production environment it is not able to suppress the data with Zero values. (This problem occurs only on Access Point Production environment and not on Desktop).

Is there any setting I have to make on Server configuration to resolve this issue.

Thanks and Regards

Rakesh

[Anil_Babu_Samineni]

O never faced this type of issue yet

Would you send your screenshots to look which you done from your AMI

[beck_bakytbek]

Hi Rakesh,

can you show your script-area?

[Anonymous]

Hi Anil,

Screen shot with Categories selected from the list box in Development and QA environment is as below:

SCREEN SHOT 1:

Screen shot with same categories selected from the list box in Production environment is as below:

SCREEN SHOT 2:

This is happening when i am migrating the application from DEV or QA environment (as shown in SCREEN SHOT 1)  to Production environment (as shown in SCREEN SHOT 2). In Production environment it is setting the excluded categories to $0 and displaying all of them.

[omkarvamsi]

hi,

my suggestion is avoid null values using set analysis in expressions.

example:

sum({<Dim-={'*'}>}sales)

[jonathandienst]

Are you running the same version of QV (desktop and all server environments)?

[sdmech81]

HI ,

Please check the QV version on both Dev and prod and reply as it will help us

Sachin

[Anonymous]

Hi Jonathan,

Yes we are using different versions as can be seen below:

Version 12.0.20001.0 SR1 64-bit (DEV and QA both Desktop and Access Point work fine).

Version 12.0.20100.0 SR2 64-bit (PROD only Desktop working correctly, have problem only with Access Point).

Regards

Rakesh

[Anonymous]

Dear Omkar,

I think if you have a re-look at the screen shots I provided, I do not have the null values. The chart is not filtering the data correctly based on the selection made in the Category List box. It is showing all the Categories and calculating the Expression to $0 for excluded categories.

Regards

Rakesh

[sravanthialuval]

Hi,

Try this,

To avoid null values in Expression it's better to use set Analysis instead of Suppress null values.

Sum({<[field name]-={'0'}>}measure)