Create a single dimension from multiple fields

[BrunPierre]

Hello there,

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.

Code	# of laptop	# of desktop	# of server	# of tablet
d1	0	1	0	1
a2	23	3	0	0
a3	12	5	0	0
f1	0	14	0	0
e3	0	12	0	0
z2	0	5	1	0

[vinieme12 · Accepted solution]

Use crosstable load

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

crosstable(Asset,CountOf,1)
Main:
Load Code,[# of Laptop],[# of Desktop],[# of server],[# of tablet]
From XyzSource;