Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

8 Replies

Re: Help

Minimum and Maximum of what?

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

qlikpahadi07
Valued Contributor

Re: Help

please attach a sample with output

Not applicable

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

Not applicable

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:

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;

Not applicable

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

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)

Not applicable

Re: Help

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

Community Browser