urgent

[#1]

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

[its_anandrjs]

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()

));

[#3]

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?

[its_anandrjs]

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

[#5]

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