topic Syntax for not equal sign in set analysis in QlikView

Syntax for not equal sign in set analysis

Sun, 01 Aug 2010 23:32:31 GMT

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)

Syntax for not equal sign in set analysis

llauses243 — Mon, 02 Aug 2010 00:10:27 GMT

Hi,

BB_INTERNAL no equal to used in expression (BG_INTERNAL)

/Luis

Syntax for not equal sign in set analysis

Mon, 02 Aug 2010 00:35:45 GMT

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

Syntax for not equal sign in set analysis

Mon, 02 Aug 2010 00:46:57 GMT

Harsh,

You can try

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

Nimish

Syntax for not equal sign in set analysis

Mon, 02 Aug 2010 01:01:16 GMT

Thanks Nimesh. It worked !!