topic Re: 'not equal to' in set analysis in QlikView

'not equal to' in set analysis

surajap123 — Wed, 14 May 2014 11:30:45 GMT

Hi All,

The values for field type is A, B and c

=sum({<Type -= {'A'}>}Total)

I want to filter the data of A. so, i have written the above modifier. But its not working.

Is not equal to(-=) correct in the modifier?

Re: 'not equal to' in set analysis

tresB — Wed, 14 May 2014 11:33:07 GMT

It's correct, issue could be somewhere else. Try to share your issue sample app.

Re: 'not equal to' in set analysis

Anonymous — Wed, 14 May 2014 11:33:24 GMT

Try like this:

sum({<Type <> {'A'}>}Total)

'<>' Represents the not equal operator in Qlikview

Re: 'not equal to' in set analysis

maleksafa — Wed, 14 May 2014 11:35:16 GMT

the -= operator is used to define exclusion in the data selection, so your expression should return the data with Type <> 'A'.

you are using the correct operator for the exclusion.

Re: 'not equal to' in set analysis

nizamsha — Wed, 14 May 2014 11:39:54 GMT

Ur expresssion is correct only but when u use the minus before equal to, u can also get the correct output but red lines will come under the expression

but when u use this one u wont get the redlines

=sum({$-<Type = {'A'}>}Total)

Re: 'not equal to' in set analysis

nizamsha — Wed, 14 May 2014 11:40:13 GMT

Check this one

=sum({$-<Type = {'A'}>}Total)

Re: 'not equal to' in set analysis

Anonymous — Wed, 14 May 2014 11:56:41 GMT

Hi Suraj,

If You want filter Data for 'A' only means,no minus before '=',

try this

=sum({<Type = {'A'}>}Total)

Re: 'not equal to' in set analysis

dmohanty — Wed, 14 May 2014 12:05:21 GMT

You need to Exclude or Include Type A data?

For display (Include) Type A Data: Sum({<Type = {'A'}>}Total)

For NOT to display (Exclude) Type A Data: Sum({<Type -= {'A'}>}Total)

Regards!

Re: 'not equal to' in set analysis

surajap123 — Wed, 14 May 2014 13:09:40 GMT

Hi All,

I have attached the app here.

Requirement-->In the Type list box, When i click direct it should show zero value in indirect text box. WHICH IS WORKING FINE.

In the Type list box, When i click Gross or Net it should show zero value in Direct Text box. THIS IS NOT WORKING.

I am not sure where the issue is..Pls help

Re: Re: 'not equal to' in set analysis

dmohanty — Wed, 14 May 2014 13:54:38 GMT

Hi Suraj,

PFA and check new expressions in Text Objects.

If this suits your need.

Regards!

Re: 'not equal to' in set analysis

surajap123 — Thu, 15 May 2014 08:21:58 GMT

Hi Mahanty,

Thanks for building the app. The issue is actually with the data. So I am still working on the issue.

Will post here, if i need any help..Thanks !!

Re: 'not equal to' in set analysis

dmohanty — Thu, 15 May 2014 08:26:12 GMT

Exactly!!!

That is what I figured out in minutes yesterday. But a small was change was needed in Set Analysis and that I have done already.

And its good that that you realzied the issue in data and not in expressions. Beacuse of the data, you were getting weird results!