Multiple Columns - Wrong Data Showing

[abg_emea]

Hi There,

I am very new to Qlik and I am trying to do the following pulling from an Azure database:

Source:

Order Number	Burgers	Sausages	Fries	Nuggets
123	1	1	1	0
124	1	1	2	2
125	0	0	1	1

Output:

	Orders
Burgers	1
Sausages	2
Fries	3
Nuggets	2

If it matters there are around 10 other columns which we are using elsewhere in the workspace.

It looks like cross table may be what I need but I cannot figure it out for the life of me.

[abg_emea]

I forgot to add - I would be grateful for any help!

[Gysbert_Wassenaar]

You can load the data using the CrossTable function with somehting like this:

MyTable:
CrossTable(Product,Orders)
SELECT * FROM ...azure_source_table_here... ;

Then you can create a table object in the front end with Product as dimension and sum(Orders) as measure.

[pradosh_thakur]

share the part of the script you are using to fetch these data.

[abg_emea]

Sure, here is the load script for the Azure table:

 The ones in bold are the products

[stuartclean]:
SELECT "Bill Payer",
"Sales Channel",
"Distribution Channel",
RRR,
"Rental Car Group Code Charged",
"Rental Car Group Code Driven",
"Location Name",
"Checkout Date",
"Checkin Date",
Leadtime,
"Mnemonic Location Code",
"Checkout Station Type",
Rental,
NOANCIL,
RSN,
"ADD",
GPS,
CSS,
CCO,
TPR,
WFI,
AFO,
STK,
BBS,
TCT,
BKF
FROM "sql".dbo.stuartclean;

[Gysbert_Wassenaar · Accepted solution]

Try:

[stuartclean]:
CrossTable(Product,Orders,14)
SELECT "Bill Payer",
"Sales Channel",
"Distribution Channel",
RRR,
"Rental Car Group Code Charged",
"Rental Car Group Code Driven",
"Location Name",
"Checkout Date",
"Checkin Date",
Leadtime,
"Mnemonic Location Code",
"Checkout Station Type",
Rental,
NOANCIL,
RSN,
"ADD",
GPS,
CSS,
CCO,
TPR,
WFI,
AFO,
STK,
BBS,
TCT,
BKF
FROM "sql".dbo.stuartclean;