Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to Get Monthwise Orders

I have enclosed file showing monthwise/datewise order received from customers.

Need below tables. Kindly help me to get the same.

Thanks in advance.

Customer NameJanuaryFebruaryMarchAprilMayJuneJulyGrand Total
ABC-2641.00492.27706.78---3840.05
DEF--1283.80829.604542.501271.003091.7011018.60
GHI1592.362564.802250.441448.501284.502110.223901.9615152.78
XYZ967.952581.97-386.41-9120.24-13056.57
Grand TOTAL2560.317787.774026.513371.295827.0012501.466993.6643068.00
1 Solution

Accepted Solutions
Not applicable

Re: How to Get Monthwise Orders

Hi,

see the attached qvw

hope this helps

Regards!

7 Replies
Not applicable

Re: How to Get Monthwise Orders

Hi,

see the attached qvw

hope this helps

Regards!

Not applicable

How to Get Monthwise Orders

Thanks.... for helping me. Is it possible to do the same without using PIVOT table?

Not applicable

How to Get Monthwise Orders

everything looks fine. But is it possible to sort this table by total vaule?

How to Get Monthwise Orders

Hi Mrkachhia,

Yes it is possible put following code sum(Total) in Sort-> Expression paste there sum(Total) select Acending or Descending order.

Regards,

Anand

Not applicable

How to Get Monthwise Orders

I have tried but not able to add sum(total) in sort. Can you show me by using the above example? Thanks

Not applicable

How to Get Monthwise Orders

OK.. I have sorted out this problem. Thanks for your help.

Re: How to Get Monthwise Orders

Hi Mrkachhia,

Oh its late response to you. See the attached file it is your solution, see expression window.

Regards,

Anand

Community Browser