Hide rows depending on the content of cells

[#1]

Hello friends,

I have created a dashboard having a table that contains many columns. It looks like this (at least the end of it):

The Exceptions field is based on the following condition:

if([Counts] = 0 and [Rolling Average Count] <> 0,'exc',if ([Counts] < 10,if([Counts]>[Rolling Average Count]*1.6 or [Counts]<[Rolling Average Count]*0.4, 'exc','ok'),if([Counts]>[Rolling Average Count]*1.25 or [Counts]<[Rolling Average Count]*0.25, 'exc','ok')))

I need to only show the rows for which the Exceptions field is = 'exc' and then hide the Exception column itself.

Any ideas on how to do that?

Thanks in advance!

Ani

[#2]

all of your expression to set 'exe' or 'ok' based on direct field values, why dont you set these flags on datamodel and it would be much easy to control values in set at per your requirement

[#3]

I guess the reason is that I am very new to Qlikview and this was my first project. Anyways, I see your point and am going to try that.

Thanks a lot!