topic Re: max dates in QlikView

max dates

Anonymous — Thu, 14 Sep 2017 11:42:51 GMT

In the excel file have some data in sheet1 and output two sheets is their . in the second one output also mentioned

but I want in qlikview script level logics

Re: max dates

Anil_Babu_Samineni — Thu, 14 Sep 2017 11:47:08 GMT

You can explain the logic behind to achieve, for output days and output block

Re: max dates

Anonymous — Thu, 14 Sep 2017 11:50:33 GMT

output days means for each product how many days blocked the data for output block

Re: max dates

Anonymous — Thu, 14 Sep 2017 11:54:32 GMT

in the

in the above snapshot data1,data2,data3,data4 blocked 3 days for this product then

output show like

Re: max dates

Anil_Babu_Samineni — Thu, 14 Sep 2017 12:16:46 GMT

Looks like you need concat() in script? Can you look help?

Sample:

LOAD Date,

Product,

data1 as ConcatData,

'data1' as Flag

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD Date,

Product,

data2 as ConcatData,

'data2' as Flag

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD Date,

Product,

data3 as ConcatData,

'data3' as Flag

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD Date,

Product,

data4 as ConcatData,

'data4' as Flag

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD Date, Product, Concat(ConcatData, '%') as Simple Resident Sample Group By Date, Product;

Re: max dates

Anonymous — Thu, 14 Sep 2017 14:22:37 GMT

I want max days count and the particular data

Re: max dates

Anonymous — Thu, 14 Sep 2017 14:22:59 GMT

its not working go to cross table logic

Re: max dates

Anonymous — Thu, 14 Sep 2017 14:34:50 GMT

go for this logic

where we write the concat function

Temp1:
CrossTable(ProductNumber, ProductName,2)
Load
Date,
Product,
data1,
data2,
data3,
data4
Resident Data;

NoConcatenate
Temp2:
Load Date, Product, Trim(ProductNumber) as ProductNumber, Trim(ProductName) as ProductName Resident Temp1;

Drop Table Temp1;

Temp3:
Load Product, ProductName, COUNT(Distinct Date) as TotalName Resident Temp2 Group By Product, ProductName;
Left Join(Temp3)
Load Product, Max(TotalName) as Mcpdays Resident Temp3 Group By Product;

Drop Table Temp2;
Join (Temp3)
Load Product, Max(TotalName) as Mcpdays Resident Temp3 Group By Product;

Left Join (Data)
Load Product, ProductName, Mcpdays Resident Temp3 Where TotalName = Mcpdays;

Drop Table Temp3;