Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Madhu,
find attached qvw.
Let me know if this helps or u have some other requirement.
Hello,
Try this one
=ONLY( {<ServiceEventID={10000}, ProfitCenterName={'a'}>} Manager)
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
hi,
if there is no requirement to show 'Zero' values then you can check the option
Suppress Zero values in presentation tab.
great!