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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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 (1)
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.