problem with set analysis

[Anonymous]

Hi

I have problem with set analysis

I wanna count numbers equal to -1 in field success

I write this set expression that this site Set Analysis Wizard for QlikView | qlikblog.at create for me but it doesn't work:

Count({$<success={-1}>}success)

this is my field's data:

I would appreciate if anyone can help

[sunny_talwar · Accepted solution]

Why don't you try this

-Sum(Success)

[sunny_talwar]

Or this

Sum(-Success)

[oscar_ortiz]

Possibly Fabs( Sum( Success ) )...

Fabs = Absolute Value

[andrei_delta]

Hello,

you must write it this way :Count({$<success={'-1'}>}success) (between single quotes)

the set interprets the minus as operator

Hope it helps,

Andrei

[Anonymous]

i tried both single and double quotes but none of them work

[Anonymous]

thank's it's work finally but i want to know why set analysis didn't work

[sunny_talwar]

Your field name seems to be Success with a capital S, did you use this

Count({$<success={-1}>}success)

or this

Count({$<Success={-1}>}Success)

In QlikView, Success is different from success

[oscar_ortiz]

I've used Count( {< Success={"-1"} >} Success) and it worked for me.  Like andrei.delta‌ mentioned.

Good luck

Oscar

[Anonymous]

wow i didn't notice that

thanks a lot