topic Re: Set operator * vs. , in QlikView

Set operator * vs. ,

thkarner — Mon, 20 Feb 2017 16:51:35 GMT

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 — Mon, 20 Feb 2017 17:10:51 GMT

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 — Mon, 20 Feb 2017 17:14:11 GMT

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. ,

thkarner — Mon, 20 Feb 2017 17:31:34 GMT

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