Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Syntax for not equal sign in set analysis

Hi All,

I am trying to use set analysis which gives me the sum(sales) for all the clients except BB_INTERNAL. I tried this but got an error. Can any one help please. Thanks in advance.

sum({$<Client <> {'BG_INTERNAL'}>} Sales)

1 Solution

Accepted Solutions
Not applicable

Syntax for not equal sign in set analysis

Harsh,

You can try

sum({$<Client -= {"BG_INTERNAL"}>} Sales)

Nimish

4 Replies
llauses243
Contributor III

Syntax for not equal sign in set analysis

Hi,

BB_INTERNAL no equal to used in expression (BG_INTERNAL)

/Luis

Not applicable

Syntax for not equal sign in set analysis

Hi Luis,

Sorry it was a typo at my end. I meant BB_INTERNAL.

Corrected :

sum({$<Client <> {'BB_INTERNAL'}>} Sales)

I cant find the syntax for a not equal sign inside a sset analysis. I am not sure if this the right way to do it. Thanks

Not applicable

Syntax for not equal sign in set analysis

Harsh,

You can try

sum({$<Client -= {"BG_INTERNAL"}>} Sales)

Nimish

Not applicable

Syntax for not equal sign in set analysis

Thanks Nimesh. It worked !!