Qlik Community

Ask a Question

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:

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