Report and calcul TOP 3 element

[pgarcia75]

Hello

I loaded a file Excel in Qlickview (see attached file )

I would like to show (to take in report for exemple) for the most recent month ( field 'period ') , the 3 fields 'service' with the field ' tx_exhaust ' the highest

For example, using as an example the file,

I want to view

IMMUNO CL DIAB 99

HEPATOLOGY 99

GYNECO.OBSTE 92

For the period May 2015 (TOP 3)

Thanks for your help

Patrice

[nigel987 · Accepted solution]

Hi patrice,

is this your desired result?

1) I created a chart -> straight table

2) Select the dimension service

3) Use the expression =max({$<periode={'$(=Max(periode))'}>} tx_exhaust)

4) In the chart properties, tab Dimensions, select 'Restrict which values ...' and also 'Show only largest 3 values'

[maniram23]

Hi,

I think this is use full for you.

first 3 LOAD site,

     libpole,

     periode,

     annee,

     mois,

     service,

     tx_exhaust

FROM

[..\...\QlickView.xls]

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

[pgarcia75]

Yes, great !

Thanks for all