topic Re: Field Name , Value in QlikView

Field Name , Value

vvvvvvizard — Fri, 06 Oct 2017 08:28:12 GMT

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

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

Re: Field Name , Value

shanky1907 — Fri, 06 Oct 2017 08:31:22 GMT

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

Re: Field Name , Value

Fri, 06 Oct 2017 08:36:18 GMT

Can you please share what output you are expecting.

Re: Field Name , Value

vvvvvvizard — Fri, 06 Oct 2017 08:36:50 GMT

Its together in one table

Re: Field Name , Value

shanky1907 — Fri, 06 Oct 2017 08:49:21 GMT

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

Re: Field Name , Value

vvvvvvizard — Fri, 06 Oct 2017 08:56:29 GMT

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

Re: Field Name , Value

Fri, 06 Oct 2017 08:58:53 GMT

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.

Re: Field Name , Value

Fri, 06 Oct 2017 09:02:44 GMT

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.

Re: Field Name , Value

tresB — Fri, 06 Oct 2017 09:03:57 GMT

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

Re: Field Name , Value

vvvvvvizard — Fri, 06 Oct 2017 09:07:57 GMT

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

Re: Field Name , Value

vvvvvvizard — Fri, 06 Oct 2017 09:24:05 GMT

Thanks, i forgot to mentio their is a key field , which allows the Generic load to work