Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pgarcia75
Contributor III
Contributor III

Report and calcul TOP 3 element

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

1 Solution

Accepted Solutions
nigel987
Creator II
Creator II

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'

View solution in original post

3 Replies
nigel987
Creator II
Creator II

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
Creator II
Creator II

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
Contributor III
Contributor III
Author

Yes, great !

Thanks for all