topic Standard deviation for a calculated column in QlikView

Standard deviation for a calculated column

sathish_kumar — Sat, 16 Nov 2024 21:33:22 GMT

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 — Wed, 23 Jan 2019 05:41:26 GMT

Hi, sathish_kumar

How about with this formula?

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

Thanks.

sathish_kumar — Wed, 23 Jan 2019 08:30:23 GMT

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 — Wed, 23 Jan 2019 09:27:12 GMT

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.