8 Replies Latest reply: Dec 16, 2010 1:16 PM by Sravan Puppala RSS

    SetAnalysis+ Aggr

    Sravan Puppala

      Hello Guys,

       

      I am struggling with this formula to get it correct in Qlikview as in Excelsheet, It involves Setanalysis and Aggr function. I would be thankful if anybody can help me.

      [View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/ForumProblem.xlsx]

      From this sheet, I want the values in Red and Green to be calculated in Qlikview.

      My try is in this .qvw

      [View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/ProblemForum.qvw]

       


      Attached Excelsheet and Qlikview application.

      Thanks

      Sravan

        • SetAnalysis+ Aggr

          Hi

          At a quick look on it I see two problems. I would try to load in the data for product A and B separately as you have no way of distinguish them now.

          Second, when you use aggr, remember to also put in your dimensions (in this case Prod A and B which you need to name as a column)

          aggr(expression, dimension)

          Then you can do the sum. I will have a closer look if I get the time later.

           

          //John