Set operator * vs. ,

[thkarner]

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

[Peter_Cammaert]

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

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

[Peter_Cammaert · Accepted solution]

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.

[thkarner]

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