Standard deviation for a calculated column

[sathish_kumar]

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

[LVillage · Accepted solution]

Hi, sathish_kumar

How about with this formula?

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

Thanks.

[sathish_kumar]

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]

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.