Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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

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

Highlighted
Contributor III
Contributor III

Yes, great !

Thanks for all