Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Test_data_edi_qlikview.xlsx

Not applicable

Test_data_edi_qlikview.xlsx

Hi All,

Need to make the following overview pivot table in qlikview.

RijlabelsONLY EDI ORDERSTOTAL ORDERS
LO_BG02
LO_TR214
LO_WG44
Eindtotaal620

Need a possibility to make a selection on date from and to

Give an overview of all orders and only the edi orders (DIRECTIVE)

Can someone help me out ?

Tks

Rudi

Labels (1)
Comments
p_verkooijen
Not applicable

Rudi,

First of all you've created a file in the resource library instead of creating a discussion (Start a conversation or ask a question)

Now i'm not able to attach a example

Go to the script editor, add

LOAD SITE,

     DIRECTIVE,

     EDI,

     PERMIS_TYPE,

     QTY,

     WEIGHT,

     NR_PLATE,

     ARRIVAL_TIME,

     DATE(FLOOR(ARRIVAL_TIME)) AS Date

FROM

[Test_data_edi_qlikview.xlsx]

(ooxml, embedded labels, table is Data);

in the dashboard create a straight table and a slider or listbox

2014-07-03 21_48_49-QlikView x64 - [C__Users_p.verkooijen_Pictures_Desktop_edi_edi.qvw_].png

Maybe try this to get you started using Qlikview

QlikView Free Training - Business Intelligence (BI) Reporting Software Solutions | Qlik

Version history
Revision #:
1 of 1
Last update:
‎07-03-2014 11:40 AM
Updated by: