topic issue regarding sub field in QlikView

issue regarding sub field

Wed, 25 Nov 2020 16:16:04 GMT

for example if i have a table like below

mobiles features

i phone wifi,bluetooth,

blackberry wifi,whatapp

moto hotspot,2gb ram

micromax wifi,facebook

now i want to create a list box featuring only wifi

thanks in advance

Re: issue regarding sub field

Chanty4u — Wed, 15 Feb 2017 06:19:47 GMT

Hi,

Try below script

LOAD * INLINE [

mobiles, features

i phone, wifi, bluetooth

blackberry, wifi, whatapp

moto, hotspot, 2gbram

micromax, wifi, facebook

];

Result:

LOAD

mobiles,

subfield(features ,',') as fea

Resident a

Where features like 'wifi';

Re: issue regarding sub field

ishanbhatt — Wed, 15 Feb 2017 07:17:22 GMT

Hi Kenchala,

mobiles features

i phone wifi,bluetooth,

blackberry wifi,whatapp

moto hotspot,2gb ram

micromax wifi,facebook

now i want to create a list box featuring only wifi.

So you need to use Subfield function in Script.

Use below line in Script.

if(Subfield(Feature,',',1)='Wifi',Subfield(Feature,',',1),'') AS FieldName.

If you want to give any value where no wifi value found in the field then add value in the else part of the if condition.

Hopefully this'll work.

Re: issue regarding sub field

sasikanth — Wed, 15 Feb 2017 07:37:14 GMT

Try this in Listbox expression:

=if(wildmatch(features,'*wifi*'),mobiles)

script:

LOAD * INLINE [

mobiles, features

i phone, 'wifi, bluetooth'

blackberry, 'wifi, whatapp'

moto, 'hotspot, 2gbram'

micromax, 'wifi, facebook'

];