topic Re: How to Calculate Post Date Order Values? in QlikView

How to Calculate Post Date Order Values?

Tue, 23 Dec 2014 05:15:10 GMT

Hi QV Team,

I need help on my Expression, How to sum-up Post Dated Order Values?

I've attached my excel sheet. Pls give me the expression to achieve this.

Re: How to Calculate Post Date Order Values?

jyothish8807 — Tue, 23 Dec 2014 05:20:52 GMT

Hi Murali,

Can you explain a bit more? what do u mean by post dated over here.

other wise simply create a straight chart:

Dimension: Date

Expression: sum(Value)

Regards

Re: How to Calculate Post Date Order Values?

Tue, 23 Dec 2014 05:26:41 GMT

Hi,

There are some “orders”. These are orders where the delivery date is after the current date. I just need a new Column in Table box which shows all Future Date(Post Date) Orders need to sum up.

If[orders Date] > Today() then I need to sum(if(if blah blah... Pls help me

Re: How to Calculate Post Date Order Values?

anbu1984 — Tue, 23 Dec 2014 05:36:10 GMT

Can you post expected output

Re: How to Calculate Post Date Order Values?

Tue, 23 Dec 2014 05:40:16 GMT

Only It has to sum up all the Order values which is greater than today's date.

Re: How to Calculate Post Date Order Values?

anbu1984 — Tue, 23 Dec 2014 05:56:42 GMT

In chart,

Dimension: First Delv Date

Expression:

If([First Delv Date] < Today(), Sum(TOTAL If([First Delv Date] >= Today(), [Open Order])))

If([First Delv Date] < Today(), Sum([Open Order]))

Re: How to Calculate Post Date Order Values?

Tue, 23 Dec 2014 05:57:33 GMT

Hi Murali ,

take a straight table or pivot table

take dimension as date field and

in expression write the following

sum(if(datefield>today(),value))

Try it out

Re: How to Calculate Post Date Order Values?

jyothish8807 — Tue, 23 Dec 2014 05:58:08 GMT

Hi Murali,

PFA

Regards

Re: How to Calculate Post Date Order Values?

tyagishaila — Tue, 23 Dec 2014 06:11:09 GMT

Is this your requirement?

Plz show your expected result so that it will clear to us to find the actual result.

Re: How to Calculate Post Date Order Values?

tyagishaila — Tue, 23 Dec 2014 06:21:52 GMT

Re: How to Calculate Post Date Order Values?

Sun, 28 Dec 2014 15:08:15 GMT

Hi Murali,

You can also try using the Set Analysis Syntax :

=Sum({$<[First Delv Date]={'>$(=(Today()))'}>} [Open Order])

Regards,

Kalyan