topic Re: set analysis - difference between -= and =- operations in QlikView

set analysis - difference between -= and =- operations

konidena — Fri, 18 Sep 2015 08:39:09 GMT

Hi All,

Please someone clarify me that the difference between the operators -= and =-.

Below is the inline load

LOAD * INLINE [

name, salary

srinivas, 1

sriram, 2

srilatha, 3

srinath, 4

srinidhi, 5

santhosh, 6

madhu, 7

gopi, 8

aruna, 9

dhanapriya, 10

];

Created the text box in the sheet and given the below query.

=sum({<name-={"sri*"}>}salary)--------returned "40" as the result

if i use "=sum({<name=-{"sri*"}>}salary)", returning the same result.

At what situations, these both will show the difference?

Re: set analysis - difference between -= and =- operations

MK_QSL — Fri, 18 Sep 2015 09:05:53 GMT

=SUM({<name =- {'*sri*'}>}salary) and =SUM({<name -= {'*sri*'}>}salary)

will give you same result without selecting anything.

But if you select something... say srinidhi, santhosh, madhu

=SUM({<name =- {'*sri*'}>}salary) will still give you 40 but

=SUM({<name -= {'*sri*'}>}salary) will give you 13 as this expression is working wrt current selection.

So, in short, if you want SUM(Salary) excluding sri with respect to current selection use 2nd expression but if you want SUM(Salary) excluding sri but should not change based on selection in name, use 1st expression.

Hope this would make clear..

Re: set analysis - difference between -= and =- operations

konidena — Sat, 19 Sep 2015 06:25:42 GMT

Thanks manish.It makes me clear now.

Re: set analysis - difference between -= and =- operations

sunny_talwar — Sat, 19 Sep 2015 06:38:06 GMT

If you got what you were looking for, I suggest marking Manish's answer as corrrect and close the thread.

Best,

Sunny

Re: set analysis - difference between -= and =- operations

MK_QSL — Sat, 19 Sep 2015 10:07:42 GMT

Can you close the thread by selecting correct answer?