topic Re: Loading values under a Field separately as it own field in QlikView

Loading values under a Field separately as it own field

Wed, 18 Nov 2015 18:24:13 GMT

Hello QV Users,

I'm new to Qlik View and will appreciate your help on the following.

I have a Data Field labelled Pool with various Pool Types under that Field named DD, EX, PLC, BB, PO3, PO6. I will like in load script to load each Pool Type separately as it own field. Can anyone help with this please.

Thanks

Wade

Re: Loading values under a Field separately as it own field

swuehl — Wed, 18 Nov 2015 18:50:04 GMT

Please post some sample data records.

Re: Loading values under a Field separately as it own field

p_verkooijen — Wed, 18 Nov 2015 19:03:48 GMT

If you're data is like this:

Pool	DD	EX	PLC	BB	PO3	PO6
A	3	2	4	2	2	45
B	1	12	2	35	13	23
C	1	3	4	1	2	1

You should try to load it as a crosstable.

Then you will end up with a table like.

Pool	Type	Data
A	DD	3
A	EX	2
A	PLC	4
A	BB	2
A	PO3	2
A	PO6	45
B	DD	1
B	EX	12
etc

Re: Loading values under a Field separately as it own field

Wed, 18 Nov 2015 19:23:33 GMT

Paul,

On my initial load, the data will show up like this when i create a list box

Pool

PLC

PO3

PO6

What i want to achieve is to create a syntax in the load script to load the data for each Pool Type individually so when i create a list box i can do each one separately.

Example: Pool Pool2 Pool3 Pool4 Pool5 Pool6

DD EX PLC BB PO3 PO6

Hope that clarifies what i want to get done

Thanks

Wade

Re: Loading values under a Field separately as it own field

Wed, 18 Nov 2015 19:27:07 GMT

Swuehl,

On my initial load, the data will show up like this when i create a list box

Pool

PLC

PO3

PO6

What i want to achieve is to create a syntax in the load script to load the data for each Pool Type individually so when i create a list box i can do each one separately.

Example: Pool Pool2 Pool3 Pool4

DD EX PLC BB

Hope that clarifies what i want to get done

Thanks

Re: Loading values under a Field separately as it own field

swuehl — Wed, 18 Nov 2015 19:43:32 GMT

And what do you want to achieve with this table? How do you want to interact / use these fields?

I guess there are some other fields involved, how are these related and what is your final requirement?

Re: Loading values under a Field separately as it own field

Wed, 18 Nov 2015 20:08:16 GMT

Yes, there are other data fields that is associated with the field Pool. I want to be able to make each Pool Type a selected field. In that way i can make manual calculation on specific pool type within my data set.

Thanks

Wade

Re: Loading values under a Field separately as it own field

ElizaF — Wed, 18 Nov 2015 20:13:26 GMT

Hello Wade,

Have a look here: The Generic Load

I thing this is what you what to get done.

Re: Loading values under a Field separately as it own field

swuehl — Wed, 18 Nov 2015 20:22:16 GMT

I doubt this will work as you intend to work. Or maybe I am still not understanding your setting and what you want to achieve. Could you elaborate this maybe with a demo scenario (When I select Ex in field Pool2, I want ... and then I want ....)? Some sample records that illustrate your demo would be nice.

Or in case this is easier for you:

Assuming a table like

A, B, Pool

1, 2, DD

1, 3, EX

2, 4, PLC

How you want this table to be transformed? As I said, I doubt that the transformation would be better than the current state, at least as I can envision what you want to do.

Re: Loading values under a Field separately as it own field

Thu, 19 Nov 2015 19:10:21 GMT

Thanks Eliza,

This was very helpful and i can use this to achieve the results am looking for. However if you still know of another way of doing this using just the field pool please let me know. With the Generic Load i have to use at least three (3) fields to get the results am looking for. Will prefer something where i can just use field Pool.

Thanks

Wade