Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how t write !=(not equal to)

Hi,,,,,

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

Regards,

Binod Kr.

9 Replies
martin59
Specialist II
Specialist II

Hi,

the syntax for different is <>

Hope that helps you

Martin

IAMDV
Luminary Alumni
Luminary Alumni

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

magavi_framsteg
Partner - Creator III
Partner - Creator III

Hi binod.kumar.

It depends on where you execute it.

IF NOT =

IF <>

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

Not applicable
Author

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
Creator
Creator

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
Author

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
Author

try this

<>

Not applicable
Author

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

rajharraj
Contributor
Contributor

"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.