# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Not applicable

## How to Calculate Post Date Order Values?

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.

1 Solution

Accepted Solutions
Master II

Hi Murali,

PFA

Regards

KC

Best Regards,
KC
10 Replies
Master II

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

KC

Best Regards,
KC
Not applicable
Author

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

Master III

Can you post expected output

Not applicable
Author

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

Master III

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

Not applicable
Author

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

Master II

Hi Murali,

PFA

Regards

KC

Best Regards,
KC
Specialist