Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
@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.