topic Re: Re: Help in QlikView

Help

Wed, 23 Apr 2014 08:23:44 GMT

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

MK_QSL — Wed, 23 Apr 2014 08:39:23 GMT

Minimum and Maximum of what?

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

Re: Help

qlikpahadi07 — Wed, 23 Apr 2014 08:46:20 GMT

please attach a sample with output

Re: Re: Help

Wed, 23 Apr 2014 09:14:17 GMT

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: Re: Help

Wed, 23 Apr 2014 09:14:51 GMT

thank you

Re: Help

MK_QSL — Wed, 23 Apr 2014 09:21:16 GMT

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;

Re: Help

Wed, 23 Apr 2014 09:38:53 GMT

thank you

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

Re: Help

MK_QSL — Wed, 23 Apr 2014 09:54:15 GMT

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)

Re: Help

Wed, 23 Apr 2014 10:11:04 GMT

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