topic Re: Aggr Help in QlikView

Aggr Help

thomas_skariah — Wed, 17 Apr 2013 06:36:15 GMT

Hi all,

Can anyone suggest to solve the following scenario.Attached is the excel file.

I want the following filteration B_Name='Customer',Type='Act',Max of RptPeriod for each KPI code,Min of Level for each KPI code and max(flag_curr) for each KPI code.....with sum of value for each KPI_code.

Find the actual output in excel file attached.

Regards,

Tom

Re: Aggr Help

thomas_skariah — Thu, 18 Apr 2013 06:03:01 GMT

Anyone any help?

Re: Aggr Help

kaushiknsolanki — Thu, 18 Apr 2013 06:28:34 GMT

Hi,

Have a look at the attached exmaple.

Regards,

Kaushik Solanki

Re: Aggr Help

Sokkorn — Thu, 18 Apr 2013 11:10:08 GMT

Hi Tom m,

Let try this load script

[Data]:
LOAD 
    Selection, 
    Year, 
    KPI_CODE, 
    B_NAME, 
    Type, 
    RptPeriod, 
    Level, 
    Flag, 
    Flag_Curr, 
    Value
FROM
(biff, embedded labels, table is [Input$]) Where B_NAME = 'Customer' and Type = 'ACT';
[MaxRptPeriod]:
Inner Join ([Data])
LOAD
    KPI_CODE,
    Max(RptPeriod)    AS [RptPeriod]
Resident [Data] Group BY KPI_CODE;
[MinLevel]:
Inner Join ([Data])
LOAD
    KPI_CODE,
    Min(Level)    AS [Level]
Resident [Data] Group BY KPI_CODE;
[MaxFlag_Curr]:
Inner Join ([Data])
LOAD
    KPI_CODE,
    Max(Flag_Curr)    AS [Flag_Curr]
Resident [Data] Group BY KPI_CODE;

See the sample attached file.

Regards,

Sokkorn

Re: Aggr Help

Thu, 18 Apr 2013 13:12:01 GMT

See attached example. By adding the flag you can view the original data if you wish.