QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

OtherSymbol

Defines a symbol to be treated as 'all other values' before a LOAD/SELECT statement. This is a user-defined variable.

Syntax:  

OtherSymbol

Example:  

set OtherSymbol='+';

LOAD * inline

[X, Y

a, a

b, b];

LOAD * inline

[X, Z

a, a

+, c];

The field value Y=’b’ will now link to Z=’c’ through the other symbol.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?