Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

matancha
Contributor

Stdev and statistics table problems

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.

Tags (2)
1 Solution

Accepted Solutions
matancha
Contributor

Re: Stdev and statistics table problems

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

2 Replies
Highlighted
Not applicable

Re: Stdev and statistics table problems

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
Contributor

Re: Stdev and statistics table problems

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