topic Re: Stdev and statistics table problems in QlikView

Stdev and statistics table problems

matancha — Wed, 05 Dec 2012 09:57:06 GMT

Hello all.

First - sorry for my English, but I will try to do my best...

Please look at the attached qvw file.

I have a fact table with data of manufacturing rolls.

I have 2 problems.

Summay Statistics Table:
I want to create straight/pivot table instead of the collection of text objects, that I have in my qvw file.
Stdev Problem:
You can see in the attached file that has a three fields of thickness measurements.
I want to do a "Standard deviation" on all the data from this 3 fields (SampleThick1, SampleThick2, SampleThick3 ) together!
See excel file for details.
If it's possible to insert this to the table from problem no. 1 it will be excellent!
I was try with variables and concat etc... - but without of success.

Many many Thanls -

Matan.

Wed, 05 Dec 2012 14:35:38 GMT

1st - You can use an island table (see load script) then just create straight chart (see att qvw file)

2nd - i'm still working on it:P

matancha — Thu, 06 Dec 2012 06:02:31 GMT

Hi Pary Pary.

Thanks for your response. it was very helpful for me..

For the 2nd - I found a link with suggested way to solve this problem:

Attached file with my solution.

Maybe someone has a GUI solution instead of this script solution (to save memory, etc...)

Thanks again!!

Matan