topic Re: Create 2 values based on a list of values in QlikView

Create 2 values based on a list of values

dudumoscona — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have a field that contains "leaving data" - if the employee left or fired and the reason.

left starts with V and Fired start with I .

Example V - Employee found a better place

I - Employee didnt do his job

i want to create a list box that will show only 2 values of "Fired" and "left" out of all the 100 reasons and also to show the Fired/left in the table i've built - is it possible?

Re: Create 2 values based on a list of values

tresB — Wed, 28 Nov 2018 07:56:52 GMT

Try expression like:

If(Left(trim('leaving data'),1)='V', 'Left', If(Left(trim('leaving data'),1)='I', 'Fired'))

Re: Create 2 values based on a list of values

dudumoscona — Wed, 28 Nov 2018 08:14:55 GMT

Hi ,

Script wise it went fine , but i could not see the new field when i created a list box i added the syntex that i've wrote

Re: Create 2 values based on a list of values

tresB — Wed, 28 Nov 2018 08:58:12 GMT

Are you saying that the field is not created or no value is there in the field?

Re: Create 2 values based on a list of values

dudumoscona — Wed, 28 Nov 2018 09:00:58 GMT

there is no field at all, i cant choose it (not there) on the fields list

Re: Create 2 values based on a list of values

tresB — Wed, 28 Nov 2018 09:09:12 GMT

Did you run reload after modifying the script?

Re: Create 2 values based on a list of values

dudumoscona — Wed, 28 Nov 2018 09:09:15 GMT

yes 🙂

Re: Create 2 values based on a list of values

tresB — Wed, 28 Nov 2018 09:13:40 GMT

Could you share screen shot of expression with just =<new field name>?

Re: Create 2 values based on a list of values

dudumoscona — Wed, 28 Nov 2018 09:19:41 GMT

yes sure

Re: Create 2 values based on a list of values

tresB — Wed, 28 Nov 2018 09:23:24 GMT

Add one more field and see if that appears post load.
...
1 as test2,
...

Re: Create 2 values based on a list of values

dudumoscona — Wed, 28 Nov 2018 09:27:39 GMT

added 1 as test2 , was not added 😞

Re: Create 2 values based on a list of values

tresB — Wed, 28 Nov 2018 09:31:26 GMT

That probably means that the same table is being dropped somewhere in the script. Or, the table is being referenced somewhere and there you need to mention new field (where it is finally being loaded).

Re: Create 2 values based on a list of values

dudumoscona — Wed, 28 Nov 2018 09:37:37 GMT

you correct but now i've added it and can see it however the choose list contain all the list of fields and not the values of this field

Re: Create 2 values based on a list of values

dudumoscona — Wed, 28 Nov 2018 09:39:32 GMT

Re: Create 2 values based on a list of values

tresB — Wed, 28 Nov 2018 09:43:18 GMT

Now don't have to write expression for list box. You can simply refer field in list box rather than expression.

Re: Create 2 values based on a list of values

dudumoscona — Wed, 28 Nov 2018 09:53:05 GMT

the values in the list box are the fields in the script and not the rasons thats what i meant.. thats weird..