Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

No of day aggression

Hi all, I want to aggregate no of day like selected date – Net due date customer wise. I tried but not figuring what’s wrong in that please help. Please find attached sample data and expected result.

2 Replies
pradeepreddy
Valued Contributor II

Re: No of day aggression

try some thing like this...

Temp:

LOAD Customer,

     Doc,

     Line,

     Date,

     Net_Due_DateD,

     Date-Net_Due_DateD as Days1,

     Day,

     Amount,

     Product

FROM [no of days. xls.xls]

(biff, embedded labels, table is Data$);

Final:

Load Customer,

  sum(Days1) as "No.of Days",

  Sum(Amount) as Amount,

  Sum(Product) as Product

Resident Test

group by Customer;

Drop table Temp;

Highlighted
Partner
Partner

Re: No of day aggression

How would you expect the No_of_days to be 1844?