Discussion board where members can get started with QlikView.
I have enclosed file showing monthwise/datewise order received from customers.
Need below tables. Kindly help me to get the same.
Thanks in advance.
Go to Solution.
see the attached qvw
hope this helps
Thanks.... for helping me. Is it possible to do the same without using PIVOT table?
everything looks fine. But is it possible to sort this table by total vaule?
Yes it is possible put following code sum(Total) in Sort-> Expression paste there sum(Total) select Acending or Descending order.
I have tried but not able to add sum(total) in sort. Can you show me by using the above example? Thanks
OK.. I have sorted out this problem. Thanks for your help.
Oh its late response to you. See the attached file it is your solution, see expression window.