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

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