topic how t write !=(not equal to) in QlikView

how t write !=(not equal to)

Tue, 12 Jul 2011 08:36:48 GMT

Hi,,,,,

Is there any syntax or operator to write !=(not equal to)

Regards,

Binod Kr.

how t write !=(not equal to)

martin59 — Tue, 12 Jul 2011 08:38:03 GMT

Hi,

the syntax for different is <>

Hope that helps you

Martin

Re: how t write !=(not equal to)

IAMDV — Tue, 12 Jul 2011 08:47:54 GMT

Hi Binod,

I am not sure if you wanted NotEqualTo operator in Set Analysis. In Set Analysis, if you wanted to implement forced exclusion then you will need to use "~" Tilde Character on your keyboard. However, In other expressions you can use <> for exclusion. Using "-" Exclusion Set Operator returns a set of records that belong to the first but not the other set.

I hope this helps!

Cheers - DV

how t write !=(not equal to)

magavi_framsteg — Tue, 12 Jul 2011 09:20:25 GMT

Hi binod.kumar.

It depends on where you execute it.

IF NOT =

IF <>

If the one you choose doesn't work, try the other.

Re: how t write !=(not equal to)

Wed, 22 Feb 2012 12:39:17 GMT

Hi Binod

I realise you probably have this sorted by now but for the benefit of anyone else...

I always find that dropping an if into the Set works best if you need to use more than one set in an exression..

I use this often as I am constantly being asked to remove the current month from graphs/tables so that only data for completed months is visible

Eg.

Sum({$< FiscalYear={$(=max(FiscalYear))}, MonthName={"=if(MonthName<>MonthName(Today()),MonthName,)"} >}Sales)

I hope this helps someone.

Re: how t write !=(not equal to)

richardpayne — Wed, 09 May 2012 20:06:30 GMT

For set analysis "-=", as in {$<Region=-{'USA'}>}, when dealing with static values.

To be sure, try either -= or =-. I am second-guessing myself.

Re: how t write !=(not equal to)

Tue, 18 Nov 2014 01:44:00 GMT

For text comparison you can use

Not wildmatch(SubRegion ,'Americas Group','Americas Attributed')

this will return True when Sub Region is not equal to 'Americas Group' and not equal to 'Americas Attributed'

Re: how t write !=(not equal to)

Tue, 18 Nov 2014 02:14:32 GMT

try this

Re: how t write !=(not equal to)

Thu, 05 Nov 2015 16:34:08 GMT

I was having some trouble with the syntax - particularly in the script. Here's how I've found success (I was missing the parentheses).

Load Sales,

Cost,

Etc...

From

..\filename.csv

where (Production_Plant <> 'Not assigned');

Re: how t write !=(not equal to)

rajharraj — Thu, 23 Apr 2020 12:55:15 GMT

"For set analysis "-=", as in {$<Region=-{'USA'}>}, when dealing with static values.

To be sure, try either -= or =-. I am second-guessing myself."

-= or =-. both ways worked perfectly for me for a set Analysis. thank you Richard. I have been looking at somany places. did not get.

Re: how t write !=(not equal to)

madelonjansen — Wed, 04 Sep 2024 14:29:38 GMT

The difference here is the filtering/selections by users.

with =- the selections made by a user wil be disregarded for the field. With -= they will be combined with the values specified in the set analysis