Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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:

DateDelivery
01-05-20141761
02-05-20143109
03-05-20142293
04-05-2014465
Total7628

Ageing Data:

DateAgeing Value
01-05-201410
02-05-2014200
03-05-20141000
04-05-2014500

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
its_anandrjs

You can calculate this in the front end like

Dimension:- Date

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

View solution in original post

5 Replies
its_anandrjs

You can calculate this in the front end like

Dimension:- Date

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

View solution in original post

TigerisBack
Champion
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.

its_anandrjs

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])

preminqlik
Specialist II
Specialist II

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