Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

thkarner
Contributor 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

Re: Set operator * vs. ,

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.

3 Replies

Re: Set operator * vs. ,

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

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

Re: Set operator * vs. ,

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
Contributor III

Re: Set operator * vs. ,

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


Community Browser