topic Get Qty & Value for Analysis Date from Date Slabs in QlikView

Get Qty & Value for Analysis Date from Date Slabs

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

Dear Experts,

As shown below, We have one table having Plant Wise certain Date Slabs and corresponding Qty & Value for that date slab.

Second table contains a Plant & Analysis date.

In second table we want to fetch the Qty & Value for Analysis Date which is falling in the respective Date Slab.

Please guide how to map the requirement.

Regards,

Girish.

Re: Get Qty & Value for Analysis Date from Date Slabs

marcus_sommer — Thu, 30 Jun 2016 08:50:46 GMT

You need to match your FromDate and ToDate per IntervalMatch to your AnalysisDate or a Date from a master-calendar which is then connect with the AnalysisDate.

- Marcus

Re: Get Qty & Value for Analysis Date from Date Slabs

Kushal_Chawda — Thu, 30 Jun 2016 09:05:46 GMT

DataTable:

mapping LOAD Plant&FromDate+iterno()-1 as Key,

Qty&'|'&Value as Data

FROM Table

while FromDate+iterno()-1<=EndDate;

Analysistable:

LOAD Plant_1,

AnalysisDate,

subfield(applymap('DataTable',Plant_1&AnalysisDate),'|',1) as Qty_1,

subfield(applymap('DataTable',Plant_1&AnalysisDate),'|',2) as Value_2

FROM Table;