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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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..