Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Michiel_QV_Fan
Specialist
Specialist

Set analysis sum value between 2 values doesn't work

I created this expression:

sum({1<[CE.cijfer_thesis] = {">$(=avg([CE.cijfer_thesis])-Stdev([CE.cijfer_thesis]))<$(=avg([CE.cijfer_thesis])+Stdev([CE.cijfer_thesis]))">} [CE.cijfer])

which gives this result:

2018-04-29 20_05_06-QlikView x64 - [C__Users_user_Documents_Dashboard_Dashboard_6 Dashboards_Sutherl.png

and that is correct but the result of the sum does not show anything (a '-')

What am I missing here?

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel
MVP
MVP

please don't create multiple threads for the same question:

Set analysis sum value between 2 values doesn't work

thanks

regards

Marco

View solution in original post

2 Replies
MarcoWedel
MVP
MVP

please don't create multiple threads for the same question:

Set analysis sum value between 2 values doesn't work

thanks

regards

Marco

Michiel_QV_Fan
Specialist
Specialist
Author

my browser froze, apparantly the post was done therefore a duplicate..