Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
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 itSmiley Tongue

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

Community Browser