Remove rows, based on values?

[marcus_steggall]

Morning team, hope you are well.

Something so simple, is causing me a headache, which hopefully you can help

I have a straight table like below, showing four columns of differing data.

Ideally, where the worked hours are 0, i'd like to remove the whole client row.

Suggestings? That would be most welcome

Thanks

[sahadevpatil140]

can u please share sample data??

[vineetadahiya12]

Hi Marcus,

You need to put it in Set Analysis way. Can you share the expression you are using for Worked Hours. You can refer thread  Hiding rows based on condition

if this helps

[tamilarasu]

Hi Markus,

You have to write your expressions like below.

PTIM%                =>  If([Worked Hours (000s)] >0, PTIM% expression)

Revenue (000s)  =>  If([Worked Hours (000s)] >0, Revenue (000s) expression)

PTI Margin          =>  If([Worked Hours (000s)] >0, PTI Margin expression)

and make sure "Suppress Zero Values" option is ticked in Presentation tab.

[shiveshsingh]

You need below expression

if(Field>0,your expression) as Worked Hours.

Btw can you share the expression?

[marcus_steggall]

Many thanks, for your replies so far everyone

I've applied this and attached the qvw, showing the expressions.

Still show's the rows, where the worked hours are Zero.

Any idea, where I am going wrong here?

Much appreciated

[shiveshsingh]

Your attachment is having section access, please remove it and then share

[marcus_steggall]

Apologies all, section access removed!

[shiveshsingh]

I'm sorry but it's not loading,

[stabben23 · Accepted solution]

Hi Marcus,

you are actually look for a value in workhours that is grather than 0.5. You have rounded up to an Integer as format.

A work around will be to create a New Expression, a copy of Worked Hours (000s), pic 1, make sure that in number it will have Expression default. Place the Expression first, then go to Dimensions Limit and add in pic 2. Then hide the column as in pic 3.