topic Re: - symbol and = symbol differences in QlikView

- symbol and = symbol differences

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

num(count({<[Request Type]-= {'applied'}>}ISSUED),v_NumberFormat)

num(count({<[Request Type]= ,applied={'applied'}>}ISSUED),v_NumberFormat)

tell me differences between

[Request Type] - = 'x'

[Request Type]=, applied=,requested=,

Re: - symbol and = symbol differences

jyothish8807 — Tue, 21 Aug 2018 06:20:57 GMT

Hi Manoj,

[Request Type] - = 'x' --> Means all the values of field [Request Type] except 'x'

[Request Type]= ---> Means the expression will not be impacted or change if you select any values under field [Request Type]

Br,

Re: - symbol and = symbol differences

jyothish8807 — Tue, 21 Aug 2018 06:22:15 GMT

I would recommend you to go through this to learn more about set analysis.

Set Analysis: syntaxes, examples

Re: - symbol and = symbol differences

tresB — Tue, 21 Aug 2018 06:22:22 GMT

[Request Type]=, // ignore selection in [Request Type] field

[Request Type] - = {'x'} // consider current selection of the field [Request Type] excluding value 'x'

applied=,requested=, // had they been field, it would have meaning like in the first line explained

Re: - symbol and = symbol differences

tresB — Tue, 21 Aug 2018 06:51:55 GMT

[Request Type] - = 'x' --> Means all the values of field [Request Type] except 'x'

This is not exactly correct. First, it would be, like: [Request Type] - = {'x'}.

And, when you put negation symbol ('-') before '=' sign, that means, the value(s) in the list (within curly braces) would be excluding from the set taking into consideration - the current selection. However, if you put the negation symbol ('-') after the '=' sign, like: [Request Type] = -{'x'}, it means, like you said : all values (irrespective of selection in the field) except 'x'.

Re: - symbol and = symbol differences

jyothish8807 — Tue, 21 Aug 2018 07:05:11 GMT

Thanks tresesco‌ for correcting me , My bad.

Br,