'not equal to' in set analysis

[surajap123]

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?

[tresesco]

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

[Anonymous]

Try like this:

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

'<>' Represents the not equal operator in Qlikview

[maleksafa]

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.

[nizamsha]

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)

[nizamsha]

Check this one

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

[Anonymous]

Hi Suraj,

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

try this

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

[dmohanty]

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!

[surajap123]

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

[dmohanty]

Hi Suraj,

PFA and check new expressions in Text Objects.

If this suits your need.

Regards!