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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Standard Deviation

Hi Guys,

I'm using the below expression in line chart. I need to calculate lower bound and upper bound using standard deviation(reference lines).

Num(Sum({<FileDate={"$(vMaxdate)"}>} FileSize)/Sum({<FileDate={"$(vMaxdate)"}>} RollingAvg),'#,##0%')

Please help me out. Attached my QVW file.

Thanks,

Siva.

2 Replies
Anil_Babu_Samineni

May be Search Recipes | Qlikview Cookbook

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
prma7799
Master III
Master III

Like this??