topic Re: How to remove Rows with null values ? in QlikView

How to remove Rows with null values ?

madhubabum — Fri, 13 Nov 2015 07:06:59 GMT

Hi Experts

Actually i want to suppress row where my expression has missing / null / blank values.

note : is there any chance to suppress null values conditionally ?(If it is possible please guide me)

I.e I want to remove records doesn't have manager values..

How to remove rows as null values in straight table ...

Here i am attaching Sample application and Excel file

Thanks

Madhu

Fri, 13 Nov 2015 07:34:15 GMT

Hi Madhu,

find attached qvw.

Let me know if this helps or u have some other requirement.

evgheni_tirulni — Fri, 13 Nov 2015 07:43:32 GMT

Hello,

Try this one

=ONLY( {<ServiceEventID={10000}, ProfitCenterName={'a'}>} Manager)

nigel987 — Fri, 13 Nov 2015 07:54:36 GMT

Hi Madhu,

you could also just use a table box instead of a chart!

- Create a table box

- Add the fields ProfitCenterID, ProfitCenterName, ServiceEventID and Manager

- Go to the Presentation Tab and select the checkbox 'Omit Rows Where Field is NULL '

- Finish

Hope this helps.

KR
Nihal

sasikanth — Fri, 13 Nov 2015 08:08:53 GMT

hi,

if there is no requirement to show 'Zero' values then you can check the option

Suppress Zero values in presentation tab.

evgheni_tirulni — Fri, 13 Nov 2015 08:27:26 GMT

great!