Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

Set analysis help

Is below both expression results the same

1. Sum({<id={'a','b'}, gp={'1'},name-={'N/A'}>} sales*rate)

2. Sum({<id={'a'}+{'b'}> * <gp={'1'}>* <name-={'N/A'}>} sales*rate)

1 Reply
sidhiq91
Specialist II
Specialist II

@Qlik1_User1  I did some calculation on the above lines and I got the same result. I have attached my ouput.

My expression are as below:

Exp1:Sum({<Year={'1996','1997'}, [Category Name]={'Produce'},CompanyName-={'Around the Horn'}>}LineSalesAmount)

Exp2:Sum({<Year={'1996'}+{'1997'}>*<[Category Name]={'Produce'}>*<CompanyName-={'Around the Horn'}>}LineSalesAmount)

Results were the Same.