Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sathish_kumar
Contributor II
Contributor II

Standard deviation for a calculated column

Hi

I know its simple to use Standard deviation function in Qlikview, when i want to use stdev in a calculated column then i am getting wrong results.

Can you please check the sample attached here

Labels (3)
1 Solution

Accepted Solutions
LVillage
Partner
Partner

Hi, sathish_kumar

How about with this formula?

Stdev(total Aggr(sum(Sales),Date))

Thanks.

View solution in original post

3 Replies
LVillage
Partner
Partner

Hi, sathish_kumar

How about with this formula?

Stdev(total Aggr(sum(Sales),Date))

Thanks.

View solution in original post

sathish_kumar
Contributor II
Contributor II
Author

i need to use  column label instead of sum(Sales).

This works fine.

Stdev(total Aggr(sum(Sales),Date))

but i want to replace sum(Sales) with column label? is there any other way?

LVillage
Partner
Partner

I understand.

But it is not allowed to use labels with Stdev function.
If you want to use labels, you should consider ways not to use this function.

Thanks.