Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
O never faced this type of issue yet
Would you send your screenshots to look which you done from your AMI
Hi Rakesh,
can you show your script-area?
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.
hi,
my suggestion is avoid null values using set analysis in expressions.
example:
sum({<Dim-={'*'}>}sales)
Are you running the same version of QV (desktop and all server environments)?
HI ,
Please check the QV version on both Dev and prod and reply as it will help us
Sachin
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
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
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)