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: 
Anonymous
Not applicable

not equal to statement, qlikview

Hi,

where am I going wrong here please?

 

I want to say if field State is not ‘NSW','VIC','QLD','WA','AC','NT','TAS' or 'SA' then make it ‘Other’

 

 

=if(State-={‘NSW','VIC','QLD','WA','AC','NT','TAS','SA'},'Other',State)

Any help appreciated.

LC

 

1 Solution

Accepted Solutions
avinashelite

try like this

if(State=‘NSW' or State='VIC' or State='QLD' or State='WA' or State='AC' or State='NT' or State='TAS' or State='SA',State,'Other')

View solution in original post

20 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

=IF (Match(State, NSW','VIC','QLD','WA','AC','NT','TAS', 'SA'), State, 'Other')

This is the reverse of your logic, but it produces the same result.

avinashelite

Try like this

if(State<>‘NSW' or State<>'VIC' or State<>'QLD' or State<>'WA' or State<>'AC' or State<>'NT' or State<>'TAS' or State<>'SA','Other',State)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Maybe you should replace all ORs with ANDs...

ajsjoshua
Specialist
Specialist

hi

try this


=if(State=-{‘NSW','VIC','QLD','WA','AC','NT','TAS','SA'},'Other','$')


Anonymous
Not applicable
Author

Thanks but didn’t work

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

Anonymous
Not applicable
Author

Thanks, but didnt work

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

Anonymous
Not applicable
Author

Thanks but didn’t work

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

PrashantSangle

Hi,

try with wildmatch() of match() with not

=if(not match(State,‘NSW','VIC','QLD','WA','AC','NT','TAS','SA'),'Other',State)


Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
stephenedberkg
Creator II
Creator II

if(State = {‘NSW'},Other,

if(State = {‘VIC'},Other,

if(State = {‘QLD'},Other,

if(State = {‘WA'},Other,

if(State = {‘AC'},Other,

if(State = {‘NT'},Other,

if(State = {‘TAS'},Other,

if(State = {‘SA'},Other,State

))))))))