Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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

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

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