topic not equal <> in set analysis in QlikView

not equal <> in set analysis

Mon, 20 Feb 2012 16:04:17 GMT

Hello,

I'm looking for the good syntaxe in set analysis to have the not equal expression:

For exemple I want have the amount of sales for all my articles but not my "Jean" in the past year.

so I did : Sum({<Year={$(=Only(Year)-1)},Article-={'Jean'}>} AmountSales)

But the symbol : -= is underline like if it's wrong.

So what is the good syntaxe for exclude always an article ?

(I don't want use the IF syntaxe)

Thank you

Re: not equal <> in set analysis

swuehl — Mon, 20 Feb 2012 16:06:13 GMT

I believe -= is correct syntax, but the expression dialog marks it wrongly as error. It's a bug.

edit:

This equivalent syntax should not be highlighted as error:

Article = Article - {'Jean'}

not equal <> in set analysis

jagan — Mon, 20 Feb 2012 16:08:23 GMT

Hi,

Can you try this

=Sum(AmountSales) - Sum({<Year={$(=Only(Year)-1)},Article= {'Jean'}>} AmountSales)

The above expression get sales of all the values and then subtracts the Last year Jean sales.

Hope this helps you.

Regards,

Jagan.

Re: not equal <> in set analysis

Thu, 23 Feb 2012 20:27:08 GMT

Hi,

@swuehl

Thank you, This is a good answer but there is still a bug and the expression dialog marks it wrongly as error

@jagan mohan

This is works fine but not really pretty, nevertheless thank you.

See you guys

Re: not equal <> in set analysis

rbecher — Thu, 23 Feb 2012 21:37:08 GMT

It says "Expression OK" and it's working. So I wouldn't think about the false underlining...

BTW, {Jean} without the quotes should be faster..

- Ralf

Re: not equal <> in set analysis

rajeshvaswani77 — Fri, 24 Feb 2012 00:36:28 GMT

The syntax is correct, I have also seen false red underlining like you and started to suspect the syntax. You are on the right path.

-RV

not equal <> in set analysis

SunilChauhan — Fri, 24 Feb 2012 08:30:54 GMT

i am agree with Rajesh

use below code

Sum({<Year={$(=Only(Year)-1)},Article-={"Jean"}>} AmountSales)

hope this helps

not equal <> in set analysis

CELAMBARASAN — Fri, 24 Feb 2012 09:08:33 GMT

Hi,

Your syntax is correct its a bug in checking the syntax of the expression by qlikview.

Celambarasan

Re: not equal <> in set analysis

kruppas78 — Thu, 13 Sep 2012 14:26:38 GMT

If you want a clear Syntax, without underline, you can use this:

Sum({<Year={$(=Only(Year)-1)},Article={"*"}-{Jean}>} AmountSales)

I Did not test this now, but i use the same type with many functions.

Stefan

Re: not equal <> in set analysis

rbecher — Thu, 13 Sep 2012 16:35:28 GMT

But -= should perform much better.

Re: not equal <> in set analysis

Fri, 22 Jan 2016 09:17:20 GMT

Hi,

Try Sum({<Year={$(=Only(Year)-1)},Article={'*'}-{'Jean'}>} AmountSales)