Loading values under a Field separately as it own field

[#1]

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

[swuehl]

Please post some sample data records.

[p_verkooijen]

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

[#4]

Paul,

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

Pool

DD

EX

PLC

BB

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

[#5]

Swuehl,

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

Pool

DD

EX

PLC

BB

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

[swuehl]

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?

[#7]

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

[ElizaF]

Hello Wade,

Have a look here: The Generic Load

I thing this is what you what to get done.

[swuehl]

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.

[#10]

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