3 Replies Latest reply: Sep 15, 2012 8:54 AM by Jason Michaelides RSS

    age wise sum

      i need to get the sum value of the stock so i need to create salb "90-120" "120-180"

       

      Ihave two diffrent date range one is stock date other one is selected days.how to get the day wise summery

      please give me the answer

        • Re: age wise sum
          Jason Michaelides

          Please provide examples of the data and the output you require.

            • Re: age wise sum

              What i need is i need to create age analasys report for stock item wise and location wise

              my problem is i can't create logic i already crete logic using excel but qlikview still am finding

              i will attache you to excel file

               

              think my date 2012/08/25 -480    i need find my stock location table how it define

               

              ex -Age=0to90 /90-120 like wise

              plase help on the i ll attache my file to you

               

               

               

               

              this exsampale

               

              selected Date(Mainstock Date)   /     Stock Qty

              2012-08-25                                         56

               

               

               

              location date                    Stock qty

               

              25/08/201225
              15/08/201210
              03/07/201215
              18/06/201230
              10/06/20123
              08/05/201220

               

               

               

               

               

              0-3031-6061-90
              35152

              I need to create this report

               

               

              Bold color items are Data please give me the help