Skip to main content

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 
Search instead 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
jyothish8807
Master II
Master II

Hi Murali,

PFA

Regards

KC

Best Regards,
KC

View solution in original post

10 Replies
jyothish8807
Master II
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

anbu1984
Master III
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.

anbu1984
Master III
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

jyothish8807
Master II
Master II

Hi Murali,

PFA

Regards

KC

Best Regards,
KC
tyagishaila
Specialist
Specialist

Is this your requirement?

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

tyagishaila
Specialist
Specialist