topic Re: not equal in QlikView

not equal

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

Iam trying to add an expression for not equal but does not work

Sum({<Country= {'01 '},[Sales] -= {'Insurance'}>}Values)

any suggestions

sunny_talwar — Mon, 11 Jul 2016 13:05:33 GMT

Have you made sure that the first part of the set analysis is not the issue here? I guess just focus on the second pary

Sum({<[Sales] -= {'Insurance'}>}Values)

This should sum all Values except for those where Sales = Insurance

trdandamudi — Mon, 11 Jul 2016 13:05:43 GMT

The expression looks ok to me except there is a space {'01 '}. Try as below:

Sum({<Country= {'01'},[Sales] -= {'Insurance'}>}Values)

See if this works...

Anil_Babu_Samineni — Mon, 11 Jul 2016 13:12:28 GMT

I am not sure, Something like below

Sum({<Country = {01}, Sales -= {"Insurance"}>} Values)

Sum({<Country = {01}, Sales =- {"Insurance"}>} Values)

Sum({<Country = {01}, {<Sales = {*} - Sales = {"Insurance"}>}>} Values)

raadwiptec — Mon, 11 Jul 2016 13:14:30 GMT

hi sunny

i just tried with this Sum({<[Sales] -= {'Insurance'}>}Values) still it is the same .. i get values but it is wrong

basically iam trying to exclude insurance take all other categories

but if spoecify

Sum({<Country= {'01'},[Sales] = {'Leasing','X','Rent'}>}Values) - it gives me correct results. but i need to enter many categories..

sasikanth — Mon, 11 Jul 2016 13:20:10 GMT

Also try this,

Sum({$<Country= {'01'},[Sales] ={'*'}- {'Insurance'}}>}Values)