Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading values under a Field separately as it own field

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

9 Replies
swuehl
MVP
MVP

Please post some sample data records.

p_verkooijen
Partner - Specialist
Partner - Specialist

If you're data is like this:

PoolDDEXPLCBBPO3PO6
A3242245
B1122351323
C134121

You should try to load it as a crosstable.

Then you will end up with a table like.

 

PoolTypeData
ADD3
AEX2
APLC4
ABB2
APO32
APO645
BDD1
BEX12
etc
Not applicable
Author

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

Not applicable
Author

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
MVP
MVP

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?

Not applicable
Author

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
Creator II
Creator II

Hello Wade,

Have a look here: The Generic Load

I thing this is what you what to get done.

swuehl
MVP
MVP

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.

Not applicable
Author

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