topic Re: Remove rows, based on values? in QlikView

Remove rows, based on values?

marcus_steggall — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Remove rows, based on values?

sahadevpatil140 — Thu, 22 Feb 2018 08:58:33 GMT

can u please share sample data??

Re: Remove rows, based on values?

vineetadahiya12 — Thu, 22 Feb 2018 09:07:54 GMT

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

Re: Remove rows, based on values?

tamilarasu — Thu, 22 Feb 2018 09:11:44 GMT

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.

Re: Remove rows, based on values?

shiveshsingh — Thu, 22 Feb 2018 09:33:58 GMT

You need below expression

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

Btw can you share the expression?

Re: Remove rows, based on values?

marcus_steggall — Thu, 22 Feb 2018 10:29:41 GMT

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

Re: Remove rows, based on values?

shiveshsingh — Thu, 22 Feb 2018 10:54:55 GMT

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

Re: Remove rows, based on values?

marcus_steggall — Thu, 22 Feb 2018 11:55:01 GMT

Apologies all, section access removed!

Re: Remove rows, based on values?

shiveshsingh — Thu, 22 Feb 2018 12:42:57 GMT

I'm sorry but it's not loading,

Re: Remove rows, based on values?

stabben23 — Thu, 22 Feb 2018 13:06:49 GMT

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.

Re: Remove rows, based on values?

stabben23 — Thu, 22 Feb 2018 13:19:27 GMT

Sorry, grather that 0.49 should gives you better result. I'm not sure if you want to se the negative values like -8?

Re: Remove rows, based on values?

marcus_steggall — Thu, 22 Feb 2018 14:40:17 GMT

excellent, working like a dream that process.

Much appreciated and a good logical way of removing rows