Skip to Content
0

Remove Blank records from BEx Query

Jun 27, 2017 at 06:45 AM

97

avatar image
Former Member

Dear All,

Please have a look at below attached screen shot , where i want to remove the rows entries where the no. of rows count is blank. I dont want to show those dates in the Query result where the count is blank.

I have tried with Query property -> Rows/Cols -> Supression with Zero , but it is not working.

Please do the needful as soon as possible.

Regards,
Sanjay Gajera

+91 89050 74894

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Bhavin Vyas Jun 27, 2017 at 09:40 AM
-1

Try this,

Click on the Key-figures structure

Go to the display tab

uncheck "Structure as group. Only apply Suppression when all elements are zero"

Thanks,

Bhavin Vyas

Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters Jun 28, 2017 at 07:51 AM
0

Hi,

you can set also a condition on the number of records as a solution.

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded
Loed Despuig Jul 03, 2017 at 05:15 AM
0

Hi,

Bhavin's suggestion is correct.

Just click the name of your structure and uncheck the "Structure as group. Only apply Suppression when all elements are zero" under the DISPLAY tab.

Regards,

Loed


delete.jpg (44.6 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Both for the solution.

1

Hi Sanjay,

You are very welcome. You may now close this thread.

Regards,

Loed

0