topic Re: expression help - internet access in QlikView

expression help - internet access

Thu, 24 Jul 2014 19:06:23 GMT

Hi.

Can anyone advised on an expression that will categorise all the scenarios on the attached app into the following - they are all variations of how it should be worded:

N/A - no access

Home Computer/Laptop

Tablet

Phone

Library/Internet Cafe

Refused to say

Other

At Work

Appreciate any help.

Chris

Re: expression help - internet access

Anonymous — Thu, 24 Jul 2014 19:08:43 GMT

Use "Like". If [Internet Access] like 'at work', 'At Work',

If [Internet Access] like 'computer','Computer,

If [Internet Access] like ' Home Computer /*', Home Computer/Laptop, etc...

Re: expression help - internet access

Thu, 24 Jul 2014 19:08:49 GMT

Hi Chris,

Use upper(Internet access) in the script.

Hope this helps.

Thanks

Sabal

Re: expression help - internet access

Thu, 24 Jul 2014 19:18:00 GMT

Hi there,

Attached is an example of how to approach this. Hope it points you in the right direction.

Thanks