Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
It's correct, issue could be somewhere else. Try to share your issue sample app.
Try like this:
sum({<Type <> {'A'}>}Total)
'<>' Represents the not equal operator in Qlikview
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.
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)
Check this one
Hi Suraj,
If You want filter Data for 'A' only means,no minus before '=',
try this
=sum({<Type = {'A'}>}Total)
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!
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
PFA and check new expressions in Text Objects.
If this suits your need.
