Stdev and statistics table problems

[matancha]

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.

1. Summay Statistics Table:
   I want to create straight/pivot table instead of the collection of text objects, that I have in my qvw file.
   
2. 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.

[#2]

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 · Accepted solution]

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:

http://community.qlik.com/message/232755#232755

Attached file with my solution.

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

Thanks again!!

Matan