click through x tract q v table
DESCRIPTION
clickTRANSCRIPT
How to extract SAP table data
into QlikView
We start the Xtract QV Designer. Click Connect (1) to connect to the (local) Xtract QV Server.
www.theobald-software.com 2
Click New (1) to create a new Extraction. Enter a name for the extraction (2)
Select Table as extraction type (3) and Click Ok to continue.
www.theobald-software.com 3
In the Xtract Connection Manager fill in the logon credentials (1) and host information (2) Test the Connection (3)
and Click OK twice to confirm (4)
www.theobald-software.com 4
The Xtract Table dialog opens.
Click to open the Look Up dialog (1) Fill in the table name (2) Click to search the table (3)
www.theobald-software.com 5
Select your table (1) Click OK to confirm the selection (2)
www.theobald-software.com 6
The metadata is automatically fetched from SAP. Now select the fields you want to extract (1)
Optional you can use a Where Clause in this text field (2)
www.theobald-software.com 7
Open the settings dialog (1) and fill out the settings (2) In this example we only want to extract 100 rows.
Click OK to confirm the settings (3)
www.theobald-software.com 8
Click OK to go back to the Designer Main Screen (1)
www.theobald-software.com 9
Right click on the extraction and select Copy QV Script to generate the ready-to-use Script into the clipboard (1)
Alternatively click on Run -> Generate QlikView Script
www.theobald-software.com 10
Start QlikView and create a new document. Click to open the Script Editor (1)
www.theobald-software.com 11
Paste the Xtract QV Script from the clipboard into the Main area by pressing Ctrl + V (1)
Click OK to exit the Script Editor (2)
www.theobald-software.com 12
Click on Reload Script (1) After successful loading click to start Quick Chart Wizard (2)
Select Bar Chart (3) Click Next to go to the next screen (4)
www.theobald-software.com 13
Select CARRID from the list of the Dimensions (1) Click Next to go to the next screen (2)
www.theobald-software.com 14
Select Seatsmax from the Drop Down list (1) Click Next to go to the Next screen (2)
www.theobald-software.com 15
Leave the settings to default (1) Click Finish to end the Wizard (2)
www.theobald-software.com 16
Right click on the Chart we created. Select Properties (1)
www.theobald-software.com 17
The Chart Properties opens. Select Expressions Tab (1) Click Add (2)
www.theobald-software.com 18
Insert Sum(SEATSOCC) into the Expression Area (1) Click OK to exit the Expression Editor (2)
www.theobald-software.com 19
Click OK to exit the Chart Properties Dialog (1)
www.theobald-software.com 20
Enjoy the first result…
www.theobald-software.com 21
Play around with the data…. Seeing is believing…
www.theobald-software.com 22
www.theobald-software.com 23
If you have any questions or comments, please write at: [email protected]