Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted

Value Handling Variable - OtherSymbol

While browsing for something on QlikView help, I came across Value Handling Variable called OtherSymbol (ValueHandlingVariables/OtherSymbol). I tried to read the help, but not sure I understand what it is doing. Can somebody shed some light on this

SET OtherSymbol='+';

LOAD * INLINE [
X, Y
a, a
b, b
c, c
d, d
e, e
];

LOAD * INLINE [
X, Z
a, a
d, d
+, c
e, e
];

 Output is this

image.png

Specifically curious on why X = e, Y = e getting repeated. This has something to the order in which the X = + row is loaded... because if I load this

SET OtherSymbol='+';

LOAD * INLINE [
    X, Y
    a, a
    b, b
    c, c
    d, d
    e, e
];

LOAD * INLINE [
    X, Z
    a, a
    d, d
    e, e
    +, c
];

I get just one row for X = e, Y = e

image.png

5 Replies
Partner
Partner

Re: Value Handling Variable - OtherSymbol

Hi Sunny,

Firstly I want to say that I learnt a lot from your reply before in Qlikivew Community, and I really hope that one day I can be strong enough like you in Qlikview.

This is my first time to see the "OtherSymbol", I think it's a cool function when doing join.

And I tried in my desktop. I think:

The "+" means all values except all above values.

So when you put it on the third column, the "+" means (b,c,e).

when you put it on the last column, the "+" means (b,c).

I tried to put it on the first column, then I got 8 rows in the table. You can try it.

Thanks.

Aiolos

MVP & Luminary
MVP & Luminary

Re: Value Handling Variable - OtherSymbol

I never used this feature before and I'm also not really sure how it worked and what might be a real use-case for it (and if it had then really significantly advantages against other ways to solve the required task - especially in regard to control that only certain values/field-values are transformed).

I didn't yet a testing but I think it would be useful / necessary to include a recno() into the loadings and to view the results within the tableviewer because a tablebox within the UI creates already a join and it might lead to misinterpreting. Further it might be interesting to look with fieldvalue() on the results (maybe with an additionally load/loop) to see what is really stored.

- Marcus

Re: Value Handling Variable - OtherSymbol


@marcus_sommer wrote:

what might be a real use-case for it


This is where it really got me. What can be a use case for such a thing. Where might I feel that something like this will come in handy. May be we can invite other people to seek there response on it's usage

@rwunderlich@Henric_Cronström

Re: Value Handling Variable - OtherSymbol

thanks @uacg0009!!.

I sort of get what it is doing, but I am looking to understand where will such a behavior will come in handy.

Partner
Partner

Re: Value Handling Variable - OtherSymbol

Hi Sunny,

Actually I met a request several weeks ago, I think if I know the "othersymbol", maybe I will try to use it.
Fox example, we have different countries data, like US,UK,China,Japan and so on.
And we have a new table now, we want to left join the new table to the fact table.
For new table, we may have:
Country, Value
US, 100
UK, 200
China, 300

And for other countries, I want to give a default value like 50.
I think we can use the "othersymbol".

Aiolos