topic Re: urgent in QlikView

urgent

Thu, 17 Apr 2014 12:12:22 GMT

hello I'm new to Qlikview and I have a problem, I want to do calculations on a minimum such maximum data table. I loaded the array as a dynamic array but I'm struggling to get my variables and do my calculations

Re: urgent

MK_QSL — Thu, 17 Apr 2014 12:13:20 GMT

Min(YourFieldName) and Max(YourFIeldName)

Please elaborate more..

Re: urgent

its_anandrjs — Thu, 17 Apr 2014 12:16:54 GMT

From table load or in script you can get

Temp:

Load * inline

[

ID,Value

A,45

B,15

C,74

D,12

];

Noconcatenate

New:

Load

ID,

Max(Value) as MaxValue,

Min(Value) as MinValue

Resident Temp;

Drop Table Temp;

Re: urgent

Thu, 17 Apr 2014 12:30:02 GMT

this looks like my data. First I would like to know how to load and calculate eg the total number of calls?

Re: urgent

Thu, 17 Apr 2014 12:48:02 GMT

how to attach a file so you can actually see the data?

Re: urgent

Thu, 17 Apr 2014 12:48:42 GMT

how to attach a file so you can actually see the data?

Re: urgent

Thu, 17 Apr 2014 12:51:16 GMT

how to attach a file so you can actually see the data?

Re: urgent

its_anandrjs — Thu, 17 Apr 2014 13:17:23 GMT

Edit your thread and you get attachment details there.

Re: urgent

MK_QSL — Thu, 17 Apr 2014 13:25:12 GMT

The section where we are writing, you can find a USE ADVANCE EDITOR... (TOP RIGHT)

Select that one and you will find Attach (BOTTOM RIGHT)

Re: Re: urgent

Thu, 17 Apr 2014 13:34:59 GMT

These are the data and I would like first is that I can load without cross table?

Re: urgent

its_anandrjs — Thu, 17 Apr 2014 14:22:27 GMT

You can try for transpose table for this.

Like this way

LOAD Reçus,

[-- Entrant],

[-- Transfert],

[-- Débordement],

[-- Traités],

[-- Débordement vers...],

[-- Dissuadés],

[-- Abandonnés],

[-- Dérangement agents],

[-- Reprise pdt transfert],

[-- Reprise par le SVI],

[-- Appels transférés],

[Durée totale com],

[Durée totale attente],

[-- Hors fermeture],

[-- Saturé],

[-- Fermé],

[-- Ferié],

[-- Non logué],

[-- Sur att max atteint],

[-- Demande de transfert],

[Max agents logués],

[Traités sans attente]

FROM

data.xls

(biff, embedded labels, table is [Z PROSODIE CONSEIL$], filters(

Transpose()

));

Re: urgent

Thu, 17 Apr 2014 20:18:48 GMT

Thank you very much I was able to load the data but if I want to calculate for example the total amount of incoming calls and store it in a variable how I do. I'm really new in QlikView. If you offer me a document?

Re: urgent

its_anandrjs — Thu, 17 Apr 2014 20:28:22 GMT

In your table which is the Incoming calls data let me know but take a example for understand like

Let vIncomingCalls = Count({< CallType = {'Incoming'} >} Calls)

If there is a flag then you can calculate like above and store it any variable.

Regards

Re: urgent

Thu, 17 Apr 2014 21:09:31 GMT

Thank you but the fact is that when I type this code?