topic Re: How to Get Monthwise Orders in QlikView

How to Get Monthwise Orders

Fri, 05 Aug 2011 16:30:21 GMT

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

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

Thanks in advance.

Fri, 05 Aug 2011 16:52:04 GMT

Hi,

see the attached qvw

hope this helps

Regards!

Fri, 05 Aug 2011 18:09:50 GMT

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

Fri, 05 Aug 2011 18:38:20 GMT

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

its_anandrjs — Fri, 05 Aug 2011 18:54:18 GMT

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

Fri, 05 Aug 2011 19:28:11 GMT

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

Sat, 06 Aug 2011 10:57:15 GMT

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

its_anandrjs — Sat, 06 Aug 2011 14:56:13 GMT

Hi Mrkachhia,

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

Regards,

Anand