topic Re: Standard Deviation per Dimension in QlikView

Standard Deviation per Dimension

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

I have a table with an expression =Stdev(TOTAL [Fechamento ajustado**]), and I was expecting to get the Standard Deviation per Stiker (my dimension), but the fact is that I'm getting the same result for all Sticker. No matter If I have something selected or not.

Please check the attached picture.

How Can I calculate the Standard Deviation per each Sticker in my table or chart? And it should recalculate based on the selections made.

Thanks
Bruno

Re: Standard Deviation per Dimension

Taoufiq_Zarra — Sun, 03 May 2020 22:22:32 GMT

Maye be you have to remove TOTAL

Re: Standard Deviation per Dimension

brunolelli87 — Sun, 03 May 2020 22:57:50 GMT

Hello...

No, it's not working...

I've tried with and without TOTAL...

Thanks

Re: Standard Deviation per Dimension

brunolelli87 — Mon, 04 May 2020 16:34:17 GMT

Does anybody know why it is going on?

I still can not calculate the standard deviation for each item on my dimension...

How can I solve it?

Re: Standard Deviation per Dimension

Brett_Bleess — Wed, 27 May 2020 11:11:31 GMT

In situations like these, you really need to attach a sample QVW so folks can see the data model, expressions and chart properties etc., without that, it is going to be difficult to offer possible suggestions.

Regards,
Brett

Re: Standard Deviation per Dimension

sunny_talwar — Wed, 27 May 2020 11:18:42 GMT

I think you seem to have some kind of time dimension here. May be you need something like this

=Stdev(Aggr(YourExpression, Sticker, YourTimeDimension))