Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

how t write !=(not equal to)

Hi,,,,,

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

Regards,

Binod Kr.

8 Replies
martin59
Valued Contributor II

how t write !=(not equal to)

Hi,

the syntax for different is <>

Hope that helps you

Martin

Luminary
Luminary

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

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

Partner
Partner

how t write !=(not equal to)

Hi binod.kumar.

It depends on where you execute it.

IF NOT =

IF <>

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

Highlighted
Not applicable

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

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.

richardpayne
Contributor

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

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

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

Not applicable

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

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'

Not applicable

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

try this

<>

Not applicable

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

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');