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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

to get deviation in between max and min

It is to show maximum and minimum values and also in between are deviations from previous values.

I had 3 expressions for max , min and deviation expressions. How can I get out of max value and minimum deviation values showing?

expression for Deviation:

sum({<[Calendar Date]={">=$(=min([Calendar Date]))<=$(=max([Calendar Date]))"}>}Value)  - rangesum(below(sum({<[Calendar Date]={">=$(=min([Calendar Date]))<=$(=max([Calendar Date]))"}>}Value),-1,1)))

Labels (1)
0 Replies