Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try using generic load. Have a look here: The Generic Load
Are you using it in a table (Like together) or seperately?
Can you please share what output you are expecting.
Its together in one table
in the expression of your list box for 'Value', you can use AGGR(sum(Value), Fieldname)
A field called car and another field called house instead of beinga field value in the field called fieldname
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.
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.
Try using generic load. Have a look here: The Generic Load
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