not equal to statement, qlikview

[Anonymous]

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

[Peter_Cammaert]

=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]

Maybe you should replace all ORs with ANDs...

[ajsjoshua]

hi

try this

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

[Anonymous]

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]

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]

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

[stephenedberkg]

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

))))))))