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