Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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?

1 Solution

Accepted Solutions
MarcoWedel

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

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..