Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
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 - Contributor II
Partner - Contributor II

Hi, sathish_kumar

How about with this formula?

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

Thanks.

View solution in original post

3 Replies
LVillage
Partner - Contributor II
Partner - Contributor II

Hi, sathish_kumar

How about with this formula?

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

Thanks.

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 - Contributor II
Partner - Contributor II

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.