topic Re: How to calculate Nextday data? in QlikView

How to calculate Nextday data?

Tue, 13 May 2014 11:02:30 GMT

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.

Re: How to calculate Nextday data?

its_anandrjs — Tue, 13 May 2014 11:15:19 GMT

You can calculate this in the front end like

Dimension:- Date

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

Re: How to calculate Nextday data?

SunilChauhan — Tue, 13 May 2014 11:18:10 GMT

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

Re: How to calculate Nextday data?

Wed, 14 May 2014 12:31:28 GMT

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.

Re: How to calculate Nextday data?

its_anandrjs — Thu, 15 May 2014 15:07:01 GMT

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

Re: How to calculate Nextday data?

preminqlik — Thu, 15 May 2014 16:17:03 GMT

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