Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vvvvvvizard
Contributor III

Field Name , Value

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Field Name , Value

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

10 Replies
shanky1907
Contributor II

Re: Field Name , Value

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

Not applicable

Re: Field Name , Value

Can you please share what output you are expecting.

vvvvvvizard
Contributor III

Re: Field Name , Value

Its together in one table

shanky1907
Contributor II

Re: Field Name , Value

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

vvvvvvizard
Contributor III

Re: Field Name , Value

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

Not applicable

Re: Field Name , Value

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.

Not applicable

Re: Field Name , Value

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.

MVP
MVP

Re: Field Name , Value

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

vvvvvvizard
Contributor III

Re: Field Name , Value

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