Linking Inline Dates within Script? Please help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Linking Inline Dates within Script? Please help

neelamsaroha157 — Thu, 15 Feb 2018 17:57:10 GMT

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

The Crosstable Load

topic Re: Linking Inline Dates within Script? Please help in QlikView

Linking Inline Dates within Script? Please help

Re: Linking Inline Dates within Script? Please help