topic Re: not equal to statement, qlikview in QlikView

not equal to statement, qlikview

Anonymous — Thu, 28 Apr 2016 06:04:34 GMT

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.

Re: not equal to statement, qlikview

Peter_Cammaert — Thu, 28 Apr 2016 06:09:42 GMT

=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

avinashelite — Thu, 28 Apr 2016 06:14:19 GMT

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

Peter_Cammaert — Thu, 28 Apr 2016 06:16:01 GMT

Maybe you should replace all ORs with ANDs...

Re: not equal to statement, qlikview

ajsjoshua — Thu, 28 Apr 2016 06:19:48 GMT

try this

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

Re: not equal to statement, qlikview

Anonymous — Thu, 28 Apr 2016 06:21:54 GMT

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

Anonymous — Thu, 28 Apr 2016 06:22:30 GMT

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>

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

Re: not equal to statement, qlikview

Anonymous — Thu, 28 Apr 2016 06:22:31 GMT

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>

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

Re: not equal to statement, qlikview

PrashantSangle — Thu, 28 Apr 2016 06:23:12 GMT

Hi,

try with wildmatch() of match() with not

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

Regards

Re: not equal to statement, qlikview

stephenedberkg — Thu, 28 Apr 2016 06:23:30 GMT

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

))))))))

Re: not equal to statement, qlikview

Anonymous — Thu, 28 Apr 2016 06:24:54 GMT

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>

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

Re: not equal to statement, qlikview

Anonymous — Thu, 28 Apr 2016 06:27:18 GMT

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>

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

Re: not equal to statement, qlikview

avinashelite — Thu, 28 Apr 2016 06:28:15 GMT

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

Re: not equal to statement, qlikview

stephenedberkg — Thu, 28 Apr 2016 06:29:35 GMT

Try this

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

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

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

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

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

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

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

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

))))))))

Re: not equal to statement, qlikview

PrashantSangle — Thu, 28 Apr 2016 06:29:58 GMT

Hi,

where you are trying suggested expression.

It must work. did you get any error??

Kind Regards

Re: not equal to statement, qlikview

Anonymous — Thu, 28 Apr 2016 06:38:08 GMT

try this one

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

try this one

if(

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'

))))))))

Re: not equal to statement, qlikview

jonathandienst — Thu, 28 Apr 2016 06:43:00 GMT

>>Thanks but didn’t work

If you want useful suggestions, you need to provide more feedback about what you tried, what result you got and what result you expected. This is not a guessing game...

Re: not equal to statement, qlikview

ajsjoshua — Thu, 28 Apr 2016 06:44:14 GMT

=if(GetFieldSelections(state) = 'NSW','NSW',

if(GetFieldSelections(state) = 'VIC','VIC',

if(GetFieldSelections(state) = 'QLD','QLD',

if(GetFieldSelections(state) = 'VIC','VIC',

if(GetFieldSelections(state) = 'WA','WA',

if(GetFieldSelections(state) = 'AC','AC',

if(GetFieldSelections(state) = 'NT','NT',

if(GetFieldSelections(state) = 'TAS','TAS',

if(GetFieldSelections(state) = 'SA','SA','Other'

)))))))))

Re: not equal to statement, qlikview

Peter_Cammaert — Thu, 28 Apr 2016 06:53:45 GMT

I don't see your State value being used or displayed in the screenshot. Could it be that you're not telling us the whole story?

Almost all answers translate your request into a perfect QlikView expression. They will work flawlessly if used forexample to define a field in your Load Script. But whether they wiill do anything useful at all depends on the context of this expression. For example, in a Text Box on a sheet, it will most certainly produce a NULL value.

Please provide details about where you want to use this expression.

Re: not equal to statement, qlikview

Anonymous — Thu, 28 Apr 2016 07:02:00 GMT

ego ego