Skip to main content

%SPACE (MDX)

Inserts a blank row or column with no label. This function is an InterSystems extension to MDX.

Returned Type

This function returns an empty string.

Syntax and Details

%SPACE()

Example

SELECT {allerd.MEMBERS,%SPACE(),allersevd.MEMBERS} ON 1 FROM patients
 
 
 1 No Data Available                  3,962
 2 additive/coloring agen               423
 3 animal dander                        428
 4 ant bites                            457
 5 bee stings                           407
 6 dairy products                       460
 7 dust mites                           422
 8 eggs                                 419
 9 fish                                 429
10 mold                                 438
11 nil known allergies                1,382
12 peanuts                              441
13 pollen                               424
14 shellfish                            431
15 soy                                  455
16 tree nuts                            452
17 wheat                                419
18
19 Nil known allergies                1,382
20 Minor                              1,229
21 Moderate                           1,205
22 Life-threatening                   1,202
23 Inactive                           1,184
24 Unable to determine                1,141
FeedbackOpens in a new tab