Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

lauracastagna
Contributor

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

 

Tags (1)
1 Solution

Accepted Solutions

Re: not equal to statement, qlikview

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

20 Replies

Re: not equal to statement, qlikview

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

Re: not equal to statement, qlikview

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)

Re: not equal to statement, qlikview

Maybe you should replace all ORs with ANDs...

ajsjoshua
Contributor III

Re: not equal to statement, qlikview

hi

try this


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


lauracastagna
Contributor

Re: not equal to statement, qlikview

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

lauracastagna
Contributor

Re: not equal to statement, qlikview

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

lauracastagna
Contributor

Re: not equal to statement, qlikview

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

Re: not equal to statement, qlikview

Hi,

try with wildmatch() of match() with not

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


Regards

Regards,
Prashant Sangle
stephenedberkg
Contributor II

Re: not equal to statement, qlikview

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

))))))))





Community Browser