Field Name , Value

[vvvvvvizard]

Good day

All my data is in 2 lisboxes , field and value , fieldname which contains all field names and a field called value with the corresponding values for that field .

How do i extract the values of the field fieldname as individual fields that contain their corresponding value

Fieldname  Value

Car               3

Car                7

Car                4

House          200

House          200

when it should dispay as field Car and House instead with their corresponding values

[shanky1907]

Are you using it in a table (Like together) or seperately?

[#3]

Can you please share what output you are expecting.

[vvvvvvizard]

Its together in one table

[shanky1907]

in the expression of your list box for 'Value', you can use AGGR(sum(Value), Fieldname)

[vvvvvvizard]

A field called car and another field called house instead of beinga   field value in the field called fieldname

[#7]

Use valuelist(car,House) in dimension limit. you will get the desired result. Just go through the qlik help to understand this function better.

Hope this will help you.

[#8]

Use valuelist(car,House) in Calculated dimension. you will get the desired result. Just go through the qlik help to understand this function better.

Hope this will help you.

[tresesco · Accepted solution]

Try using generic load. Have a look here: The Generic Load

[vvvvvvizard]

It needs to be done in the script as il be loading a lot of data , house  , car is just an examples , there will be many fields and values