Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,,,,,
Is there any syntax or operator to write !=(not equal to)
Regards,
Binod Kr.
Hi,
the syntax for different is <>
Hope that helps you
Martin
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
Hi binod.kumar.
It depends on where you execute it.
IF NOT =
IF <>
If the one you choose doesn't work, try the other.
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.
For set analysis "-=", as in {$<Region=-{'USA'}>}, when dealing with static values.
To be sure, try either -= or =-. I am second-guessing myself.
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'
try this
<>
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');
"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.