max dates

[Anonymous]

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

[Anil_Babu_Samineni]

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

[Anonymous]

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

[Anonymous]

in the

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

output show like

[Anil_Babu_Samineni]

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;

[Anonymous]

I want max days count and the particular data

[Anonymous]

its not working go to cross table logic

[Anonymous]

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;