Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.