topic Re: Syntax for not equal in set analysis in QlikView

Syntax for not equal in set analysis

Tue, 24 May 2011 09:45:14 GMT

I have been using the following syntax for not equal in set analysis for a long time now:

sum({$<Field-={'Value'}>} Fact)

The thing is that the syntax check thinks it is wrong somehow as it places a red underline under the - symbol and doesn't check the syntax in the rest of the calculation.

Does anyone know if this isn't the most desirable solution anymore?

Syntax for not equal in set analysis

RicardoRamos — Tue, 24 May 2011 09:59:20 GMT

I would say that the syntax is correct. The Syntax check is not perfect when validating Set Analysis.

Re: Syntax for not equal in set analysis

kaushiknsolanki — Tue, 24 May 2011 10:05:38 GMT

Hi,

Though it shows the red line, it works properly.

Have a look at the attachment

Regards,

Kaushik Solanki

Re: Syntax for not equal in set analysis

ToniKautto — Tue, 24 May 2011 12:32:03 GMT

If the expressions works as expected even though the editor presents a red line, then it is most likely a SW bug and should be reported to QlikView for correction.

http://www.qlik.com/support

Syntax for not equal in set analysis

Thu, 16 Jun 2011 08:45:25 GMT

@Kaushik.Solanki & Ricordo: I know it works just fine but when creating a more complex expression with multiple set analysis statements it stops checking the syntax when it encounters the first -= (not equal) statement.

@Toni Kautto: I spoke with my local QlikTech partner and they confirmed this behavior. They have reported this with QlikTech so I am expecting this will be resolved in a future service release.

Thanks for your reactions.

Re: Syntax for not equal in set analysis

Fri, 01 Aug 2014 19:29:46 GMT

Hello Marc,

Even though it works, there is a bug in QlikView that makes it appear as an error. To make it go away you can try:

sum({<Field = {'*'}-{'Value'}>}Fact)

Re: Syntax for not equal in set analysis

jaimeaguilar — Fri, 01 Aug 2014 20:03:21 GMT

Hi,

This:

sum({$<Field = {'*'}-{'Value'}>}Fact)

and this: sum({$<Field-={'Value'}>}Fact) are not exactly the same, however in most cases gives you the same result. This syntax bug has been present for a long time in several functions, It seems that QlikSense no longer has this bug (at list for -=, +=, etc)

regards

Re: Syntax for not equal in set analysis

Fri, 01 Aug 2014 20:29:25 GMT

Hi,

Try this:

Sum({$<Field=Field-{'Value'}>} Fact)

Best regards.

Re: Syntax for not equal in set analysis

Fri, 10 Oct 2014 10:19:56 GMT

!Hello Team

i am using the following syntax for set analytics, it is not working fine. kindly let me know the correct syntax.

sum({<CUSTID-={[ALP]::CUSTID}>}TOTALSALE)

Desc

[ALP] is one group

Re: Syntax for not equal in set analysis

PrashantSangle — Fri, 10 Oct 2014 10:22:09 GMT

Hi,

try this

sum({<CUSTID-={"[ALP]::CUSTID"}>}TOTAL SALE)

Regards

Re: Syntax for not equal in set analysis

Fri, 10 Oct 2014 10:35:49 GMT

@max dreamer, value is not matching with the back end.

Re: Syntax for not equal in set analysis

PrashantSangle — Fri, 10 Oct 2014 10:56:43 GMT

Hi,

It is better if you start new discussion, with sample app.

So that every one can work on your issue.

Regards