cancel
Showing results for 
Search instead for 
Did you mean: 

Remove Blank records from BEx Query

sanjay_gajera
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Loed
Active Contributor
0 Kudos

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

sanjay_gajera
Explorer

Thanks Both for the solution.

Loed
Active Contributor
0 Kudos

Hi Sanjay,

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

Regards,

Loed

kohesco
Active Contributor
0 Kudos

Hi,

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

Grtz

Koen

bhavinvyas
Active Contributor
0 Kudos

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