topic Re: What does -= mean in set analysis ? in QlikView

What does -= mean in set analysis ?

Mon, 13 Oct 2014 09:14:00 GMT

Hi All,

Can someone explain what the following syntax does please ? I'm confused about the -= symbols in this expression.

(sum({$<[Product Group] -= {'- Unknown}>} [Amount]))

Thanks

Re: What does -= mean in set analysis ?

vikasmahajan — Mon, 13 Oct 2014 09:15:05 GMT

-= means NOT EQUAL TO

Vikas

Re: What does -= mean in set analysis ?

MK_QSL — Mon, 13 Oct 2014 09:15:06 GMT

-= means Not Equal to

(sum({$<[Product Group] -= {'- Unknown}>} [Amount]))

SUM(Amount) where Product Group is not Equal to Unknown

Re: What does -= mean in set analysis ?

its_anandrjs — Mon, 13 Oct 2014 09:18:21 GMT

In the mention expression

(sum({$<[Product Group] -= {'- Unknown}>} [Amount]))

The symbol combination means (-=) Not equals for the field it checks the values is not equals.

Regards,

Anand

Re: What does -= mean in set analysis ?

Mon, 13 Oct 2014 09:18:40 GMT

Thanks Vikas. Isn't it better to use <> or is that different in some way ?

Re: What does -= mean in set analysis ?

Mon, 13 Oct 2014 09:27:39 GMT

Hi,

-= Means Not equal to in set analysis

<> will not work in set analysis

Regards,

Joshmi

Re: What does -= mean in set analysis ?

Mon, 13 Oct 2014 09:34:41 GMT

Oh really. But it can be used in the script though ?

Re: What does -= mean in set analysis ?

ashfaq_haseeb — Mon, 13 Oct 2014 09:36:27 GMT

<> will work in script

-= will work in set analysis.

Regards

ASHFAQ

Re: What does -= mean in set analysis ?

datanibbler — Mon, 13 Oct 2014 09:37:17 GMT

Hi,

adding to all those answers, I can only say

that I would NOT recommend using that:

=> Though it's more elegant, the script_editor does not recognize this, so it underlines it in red and doesn't check anything further down the line, so there's no way for you or anyone else to tell if everything else is correct.

<='> Instead I would suggest going the longer way and building an expression inside your set_expression,

sth. like

>> COUNT({<[date] = {"$(= '<>' & [value])"}>} [field]) <<

Best regards,

DataNibbler

Re: What does -= mean in set analysis ?

jagan — Mon, 13 Oct 2014 09:39:11 GMT

Hi,

(sum({$<[Product Group] -= {'- Unknown}>} [Amount]) ----------- -= in set analysis will exclude the given values in set analysis.

For example:

Year, Sales

2012, 100

2013, 150

2014, 200

sum({$<Year -= {2013}>} Sales) - this expression returns 300 (100 + 200) excluding the year 2013 values.

Simply saying

sum({$<Year = {2012, 2013, 2014}>} Sales) - sum({$<Year = {2013}>} Sales)

This cannot be used in Script, in script you can <>,

LOAD

FROM Datasource

WHERE Year <> 2013;

Hope this helps you.

Regards,

Jagan.

Re: Re: What does -= mean in set analysis ?

its_anandrjs — Mon, 13 Oct 2014 09:43:50 GMT

In SET analysis if we talk about the <> it is known as modifiers and it is start with < and ends with > and in between this field name use to check values. But in SET analysis not equals is like (-=). For more details read the attached document related to SET analysis.

Regards,

Anand

Re: What does -= mean in set analysis ?

vikasmahajan — Mon, 13 Oct 2014 10:01:59 GMT

<> will not work in set analysis <> we can use in SQL Query.

vikas

Re: What does -= mean in set analysis ?

Mon, 13 Oct 2014 10:56:37 GMT

I understand what you mean as I have a red underline beneath my -= set analysis expression.

But when I tried to convert my code into your suggestion it failed. I tried a few variations but it still failed. How do I convert this line into your code

(sum({$<[Product Group] -= {'- Unknown}>} [Amount]))

Re: What does -= mean in set analysis ?

Mon, 13 Oct 2014 11:13:21 GMT

Hi,

(sum({$<[Product Group] -= {'- Unknown'}>} [Amount]))

Regards,

Joshmi

Re: What does -= mean in set analysis ?

jonathandienst — Mon, 13 Oct 2014 11:17:58 GMT

The -= is shorthand for:

Sum({<[Product Group] = {'*'} - {'- Unknown'}>} [Amount])

(ie include everything (*), but exclude '- Unknown'; or include everything except '- Unknown')

HTH

Jonathan

Re: What does -= mean in set analysis ?

Mon, 13 Oct 2014 11:20:12 GMT

Hi,

You can use <> symbol in Script but not in set analysis

Re: What does -= mean in set analysis ?

Mon, 13 Oct 2014 12:37:20 GMT

Right ! This works without any syntax errors. Many thanks for this.