Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

problem with set analysis

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:

Untitled.png

I would appreciate if anyone can help

1 Solution

Accepted Solutions
sunny_talwar

Why don't you try this

-Sum(Success)

View solution in original post

11 Replies
sunny_talwar

Why don't you try this

-Sum(Success)

sunny_talwar

Or this

Sum(-Success)

oscar_ortiz
Partner - Specialist
Partner - Specialist

Possibly Fabs( Sum( Success ) )...

Fabs = Absolute Value

andrei_delta
Partner - Creator III
Partner - Creator III

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
Not applicable
Author

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

Anonymous
Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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

275594.PNG

Good luck

Oscar

Anonymous
Not applicable
Author

wow i didn't notice that

thanks a lot