Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Linking Inline Dates within Script? Please help

Hello QV community,

I have a question regarding linking Inline entered Dates to the Dates being pulled from the system.

I have manually entered some budget figures (Inline) that look like the below (last column '2018' is the Row total):

QUALIFY *;

UNQUALIFY "%KEY_*";

Budget_2018:

LOAD * INLINE [

%KEY_Cus_Id,      Jan,    Feb,      Mar,    Apr,      May,      Jun,      Jul,      Aug,      Sep,      Oct,      Nov,      Dec,      2018

300323,                0,          5000,      0,          0,          5400,    0,          0,      5400,      0,          0,          5400,      0,      21200

300449,                7000,          0,    7560,      0,          7560,      0,      7560,      0,      7560,      0,          7560,      0,      44800

];


D_Date:

LOAD "LINK_Date" as %KEY_Date,

    Month("DATE_Date") as DateMonth;

SQL SELECT *

FROM "packaging_dwh_db".dbo."D_Date";

I would like to somehow link the Budget_2018 dates (e.g. Jan, Feb etc) with DateMonth. Please let me know if you have any suggestions on the best way to approaching this.

Thanks in advance!

Mo

1 Reply
Highlighted
Specialist II
Specialist II

Use of cross table might be your solution, if I am understanding your requirement correctly.

The Crosstable Load