topic Re: Report and calcul TOP 3 element in QlikView

Report and calcul TOP 3 element

pgarcia75 — Tue, 22 Sep 2015 14:47:08 GMT

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

Re: Report and calcul TOP 3 element

nigel987 — Tue, 22 Sep 2015 15:09:41 GMT

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'

Re: Report and calcul TOP 3 element

maniram23 — Tue, 22 Sep 2015 15:13:02 GMT

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$);

Re: Report and calcul TOP 3 element

pgarcia75 — Tue, 22 Sep 2015 15:21:10 GMT

Yes, great !

Thanks for all