3 Replies Latest reply: Feb 20, 2017 12:31 PM by Thomas Karner RSS

    Set operator * vs. ,

    Thomas Karner

      Hi,

       

      could somebody explain the exact difference of those 2 set analysis statements?

       

      1) sum({<Region={'West'}> , <Product={'Laptop'}>} Sales)


      2) sum({<Region={'West'}> * <Product={'Laptop'}>} Sales)

       

      Best regards,

      Thomas

       


        • Re: Set operator * vs. ,
          Peter Cammaert

          IMHO the first one is not a correct set analysis specification. This one is:

           

          sum({<Region={'West'}, Product={'Laptop'}>} Sales)

            • Re: Set operator * vs. ,
              Peter Cammaert

              AFAIK your second expression and mine do the exact same thing. In this simple example, that is. Yours does an intersection of two sets, mine uses two modifiers to specify the same resulting set.

                • Re: Set operator * vs. ,
                  Thomas Karner

                  Yes, you´re right. I didn´t make the syntax check :-)

                  The 2 expressions are (as you wrote)


                  1) sum({<Region={'West'} , Product={'Laptop'}>} Sales)

                  2) sum({<Region={'West'}> * <Product={'Laptop'}>} Sales)


                  So I also would say that both Expressions should do the same.

                  The strange thing is that I´m using Qlik Sense and I´ve a situation (with a pivot table and a drill down dimension) where I get different results. (I know that I´m in the wrong forum for that, but set analysis is the same in both products).


                  For the moment it´s ok for me, just wanted to have a third opionion. Now I have to do some further checks.


                  Thanks, Thomas