How to remove Rows with null values ?

[madhubabum]

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

[#2]

Hi Madhu,

find attached qvw.

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

[evgheni_tirulni]

Hello,

Try this one

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

[nigel987]

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]

hi,

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

Suppress Zero values in presentation tab.

[evgheni_tirulni]

great!