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

[omkarvamsi]

try this

sum({<measure -={'0'}>}measure )

[buzzy996]

i think $0 is not equal to null,tht's causing the issue.

work on ur expression,if ur expression value = $0 make it as null else ur value.

[Anonymous]

Hi Shiva Reddy and Sravanthi Aluvala,

I am using both Suppress Missing values and Suppress Zero values. Expression should work in case of Suppress Zero values.

I am getting this issue only on Access Point of PRODUCTION environment and NOT in Desktop or Access Point of Development or QA environment.

Regards

Rakesh

[adamdavi3s]

I would suggest patching dev to the same level as prod and see if you get the same issue.

I HAVE previously had issues with web and not desktop on the same product version which seems to be what you are experiencing.

Have you tried webview in desktop just to be sure? or are you using IE plugin?

[#6]

Hi Rakesh, Try with dimension lilmits.

1. First create a dummy expression with addition of all expressions.

2.put that expression as first expression in straight table.

3.apply the dimension limits greater than(zero) for that expression.

4.then finally hide the expression using presentation tab.

5.then the zero values suppressed.

I am also facing same problem.

The above procedure works for me.

It may work for you.

Thanks & Regards

Bhargava Reddy

[duncanblaine]

Hi Rakesh
This seems very similar to an issue I encountered today when testing an upgrade from V11.20 to V12.20.
My straight table is using a Calculated Dimension, specifically a ValueList().
Suppress Zero Values is checked by default. In V11, the zeros are showing and in V12.20 they are not.
If you are perhaps using a calculated dimension, it might be worth trying without it (ie. build the dimension in the load script).

I've posted details of my issue here Suppress Zero Values behaviour differs between QV11.20 and QV12.10 when using ValueList as dimension
Hope this helps.

Good luck!
Duncan

[Anonymous]

Dear Bhargava,

Thanks for the solution. I think this was some bug which got resolved after we upgraded to in QLIK NOV 2017 SR5 release

Regards

Rakesh

[Anonymous]

Dear Duncan,

Thanks for the solution. I think this was some bug which got resolved after we upgraded to QLIK NOV 2017 SR5 release

Regards

Rakesh