# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for
Search instead for
Did you mean:
Not applicable

## How to calculate Nextday data?

Hi All,

I Have data like below. We need to calculate Incoming data

INPUT:

Delivery Data:

 Date Delivery 01-05-2014 1761 02-05-2014 3109 03-05-2014 2293 04-05-2014 465 Total 7628

Ageing Data:

 Date Ageing Value 01-05-2014 10 02-05-2014 200 03-05-2014 1000 04-05-2014 500

Output :Need daywise data

Date                  Incoming data

01-05-2014        logic=(Next day Ageing data+current day Delivery data)-current day Ageing data

''

''

Ex:

Date                        Incoming data

01-05-2014                (200+1761)-10=1951

same for all days.

Thanks,

Ashok.

1 Solution

Accepted Solutions
MVP

You can calculate this in the front end like

Dimension:- Date

Expression:- (below(sum([Ageing Value])) + sum(Delivery))-sum([Ageing Value])

5 Replies
MVP

You can calculate this in the front end like

Dimension:- Date

Expression:- (below(sum([Ageing Value])) + sum(Delivery))-sum([Ageing Value])

Champion

sum(If(Date= Date+1,[Ageing Value])) + sum(If(Date= Date,[Ageing Value]))

Not applicable
Author

Hi Anand,

Thanks for ur reply.It working for date wise but i have two more dimensions process and sub process.that

When i applying below function there is chance to get wrong data. and if i add those two dimensions not getting proper

result.

Can suggest any other way.

Thanks,

Ashok.

MVP

Then make changes in the load script of the "Ageing Data"  add new field as [Next Day Ageing] for calculating Next day ageing See the below load script.

"Delivery Data":

LOAD * INLINE

[   Date, Delivery

01-05-2014, 1761

02-05-2014, 3109

03-05-2014, 2293

04-05-2014, 465];

"Ageing Data":

LOAD * Inline

[   Date, Ageing Value

01-05-2014, 10

02-05-2014, 200

03-05-2014, 1000

04-05-2014, 500];

NoConcatenate

"New Ageing Data":

LOAD

Date,

[Ageing Value],

if(RowNo() > 1,Previous([Ageing Value])) as [Next Day Ageing]

Resident [Ageing Data] Order By Date desc;

DROP Table [Ageing Data];

And on the front end on the chart write

Dimension:-Date

Expression:- sum([Next Day Ageing]) + sum(Delivery) - sum([Ageing Value])

Specialist II

in which table you have two more dimensions?....post sample data with adding two more dimensions

Community Browser