Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to remove Rows with null values ?

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

5 Replies
Highlighted
Not applicable

Re: How to remove Rows with null values ?

Hi Madhu,

find attached qvw.

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

Highlighted
Partner
Partner

Re: How to remove Rows with null values ?

Hello,

Try this one

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

Highlighted
Creator II
Creator II

Re: How to remove Rows with null values ?

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

Highlighted
Specialist III
Specialist III

Re: How to remove Rows with null values ?

hi,

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

Suppress Zero values in presentation tab.

Highlighted
Partner
Partner

Re: How to remove Rows with null values ?

great!