8 Replies Latest reply: Apr 23, 2014 6:11 AM by moustapha thiam

# Help

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

• ###### Re: Help

Minimum and Maximum of what?

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

• ###### Re: Re: Help

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

• ###### Re: Help

T1:

[TMC (min)],

[-- Entrant (nb appels)],

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

FROM

CH06_20140423_111000.xls

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

Join

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

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

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

Resident T1;

• ###### Re: Help

thank you

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

• ###### Re: Help

Change Join Statement as below

Join

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)

• ###### Re: Help

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

• ###### Re: Help

please attach a sample with output

• ###### Re: Re: Help

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