Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

removing zero values from an expression

I have a straight table.  One expression is =MachValue*(OpQty - (OperationYield+Scrap)) this will return zero values.  I want the straight table to report out all lines which do not have zero value.  I have tried marking the suppress zero values and suprees when null but that has not proved successful.  I don't think I can do anything different in my load because this is a calculation.  Any help is appreciated.

 


3 Replies
PrashantSangle

Hi,

Did you try with if condition.

Like

if(MachValue*(OpQty - (OperationYield+Scrap))<>0,MachValue*(OpQty - (OperationYield+Scrap)))

and also tick on supress null values.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable
Author

When I used that formula my machine time changed from zero to -. It did not remove it from my table. I still have the suppress zero and suppress null check boxes checked on the presentation tab. What is interesting is it actually changed it from a zero to a null but I still can’t get those lines to not show on my straight table. Does the picture below help at all?

Kimberly Glidewell

E-Z-GO/Textron

Systems Analyst

Phone: 706-560-6091

Fax: 706-826-1210

PrashantSangle

Hi,

As per provided expression,

It is working fine for that particular Expression only.

Just confirm it by disabling all other expression except provided solution expression.

It will give you only those value which does not contain 0.

In provided image, You are calculating some more expression also, which contain values on that row

Therefore our expression is showing -

I hope you understand, what I want to say.

One more thing if possible share you sample apps.

Regards,


Great dreamer's dreams never fulfilled, they are always transcended.