Create a single dimension from multiple fields

So essentially I want to create a single dimension by using their respective column/filename, say a Listbox called Asset, to make a selection on this laptop, desktops, server, and tablet.

Many thanks.

enter image description here

What you'd want is the CrossTable prefix (see the Qlik Help here). It allows you to "pivot" a table so that 1 record with multiple columns becomes multiple records with just 2 columns (1 column for field name, 1 column for field value).

So given your table, which we'll call [Data]:

...you can use the following Qlik script in the Data Load Editor to get the desired output:

[Pivoted]:
CrossTable ([Device], [DeviceCount], 1) Load * Resident [Data];

Drop Table [Data];


[New Data]:
NoConcatenate Load
    [Code]
  , Capitalize(SubField([Device], ' ', -1)) as [Device]
  , [DeviceCount]
Resident [Pivoted];

Drop Table [Pivoted];

That should give you this result: