Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
thkarner
Partner - Creator III
Partner - Creator III

Set operator * vs. ,

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


1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

View solution in original post

3 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Partner - Creator III
Partner - Creator III
Author

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