6 Replies Latest reply: Dec 17, 2017 6:16 PM by Luis Madriz RSS

    Issue

    balu k

      Hi All,

       

      I got a requirement like as need t dimension value grouping.

      Dimension is like as Region North, east, south, west and same in  region dimension.

      and need value as shown based grouping .

       

      How can i resolve the issue?

        • Re: Pivot Table problem
          Luis Madriz

          Hi Balu,

           

          What do you mean by "fix"? that won't change is selections are made?

          If so you just need to reset the possible selections for example

          Sum({<Dimension1=, Dimension2= ... etc. >} GrossSales)

           

          So when someone make any selection of Dimension1, 2, etc. Sum(GrossSales) won't change,

           

          I hope this helps,

           

          Luis

            • Re: Pivot Table problem
              Jonathan Dienst

              What do you want to resolve? Are you asking for (1) help with transforming that data in the load or (2) displaying in the front end. If (1), you need to explain and possibly supplysamples of your source data. If (2), then you need to describe in detail your data structure and supply a sample QVW/QVF containing some representative data.

               

              In either case, you need to explain the calculations you want to take place.

                • Re: Pivot Table problem
                  balu k

                  Hi Jonathan,

                   

                  But as per security reason i can't display and provide qvw and source data.

                   

                  here my problem want to displaying in front end .

                   

                  Gross sales and net sales are expressions. But those are need to display as horizontal basis showing in above pic.

              • Re: Pivot Table problem
                Luis Madriz

                Hi Zaid and community,

                 

                I've been trying this in Qlik Sense without much progress.

                 

                I'm using these as measures:

                if(dimensionality()=0,Sum(GrossSales)) for Gross Sales

                Sum(SalesCost) for Sales Cost >>> Sorry Zaid, I had to call it something like this to make sense in my head

                if(dimensionality()=0,Sum(GrossSales)-Sum(SalesCost)) for Net Sales

                 

                But haven't been able to remove the nulls yet. This is as far as I've made it in Qlik Sense...

                Untitled.png

                This is the data I loaded

                    

                RegionCategoryMonthSalesGrossSalesSalesCost
                EastA01/01/20172500500
                NorthA01/01/20172500200
                SouthC01/01/20172500600
                WestB01/01/20172500100
                EastA01/02/201725002000
                NorthA01/02/20172500300
                SouthC01/02/20172500200
                WestB01/02/20172500500
                EastA01/03/20172500500
                NorthA01/03/20172500800
                SouthC01/03/20172500500
                WestB01/03/20172500600
                EastA01/04/20172500600
                NorthA01/04/20172500700
                SouthC01/04/20172500300
                WestB01/04/20172500400
                EastA01/05/20172500200
                NorthA01/05/20172500600
                SouthC01/05/20172500900
                WestB01/05/20172500800