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

missing closing bracket:


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



hope this helps


regards


Marco

View solution in original post

1 Reply
MarcoWedel
MVP
MVP

missing closing bracket:


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



hope this helps


regards


Marco