Help

[#1]

Hello,

I have a data table and I want to extract the minimum and maximum of the table and then calculate the average and finally build a dashboard type boxplot.

I need help because I metrized not QlikView especially the use of these functions and expressions

[MK_QSL]

Minimum and Maximum of what?

Kindly try to explain in brief or provide some sample data file..

[qlikpahadi07]

please attach a sample with output

[#4]

this is my output table and I want to calculate the average TMC (min), extract the TMC minimum (min) and the maximum too. And I would like a dashboard of these three values ​​calculated to compare the mean of each bank to my indicators.

thank you

[#5]

this is my output table and I want to calculate the average TMC (min), extract the TMC minimum (min) and the maximum too. And I would like a dashboard of these three values ​​calculated to compare the mean of each bank to my indicators.

thank you

[MK_QSL]

T1:

LOAD Banques,

     [TMC (min)],

     [-- Entrant (nb appels)],

     [Sum ([TMC (min)]])]

FROM

CH06_20140423_111000.xls

(biff, embedded labels, table is Sheet1$);

Join

Load

  Time(Min([TMC (min)])),

  Time(Max([TMC (min)])),

  Time(Avg([TMC (min)]))

Resident T1;

[#7]

thank you

Now suppose I want to compare the TMC (min) of each bank to the overall average which function to use?

[MK_QSL]

Change Join Statement as below

Join

Load

  Time(Min([TMC (min)])) as Min(TMC),

  Time(Max([TMC (min)])) as Max(TMC),

  Time(Avg([TMC (min)]))  as Avg(TMC)

Resident T1;

Now use Simple Maths function.

[TMC (min)] - Avg(TMC)

[#9]

the script does not work. when I load the code he said, slag after intruction join