topic Re: Bar Chart With Top 10 Values along with Selected Field in QlikView

Bar Chart With Top 10 Values along with Selected Field

shabarish0587 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please see the sample data file and screen shot. In data file i have two field one field is Hospital Name and second one is Normalized Paid Amount. In Bar chart i want top 10 hospital Names based on Paid Amount.Please any tell me how to do this.

Re: Bar Chart With Top 10 Values along with Selected Field

vishsaggi — Mon, 15 May 2017 15:29:07 GMT

Use Bar chart with HospitalName as Dim and

= Sum([Normalised Average Cost]) as your expr.

Then in dimension limits tab of Chart properties check like below?

Check Restrict which values and Uncheck Show others as highlighted.

Re: Bar Chart With Top 10 Values along with Selected Field

shiveshsingh — Mon, 15 May 2017 15:58:08 GMT

Use hospital name as dimension and sum (Cost) as expression.

in dimension limits tad, select restrict check box. '

hope this helps

Re: Bar Chart With Top 10 Values along with Selected Field

Anil_Babu_Samineni — Mon, 15 May 2017 16:31:18 GMT

First of all, In your dummy data you don't have data as TOP 10

May be this in straight table as Dimension

=aggr(if(Rank(total Sum([Normalised Average Cost]))<=3, [Nombre Comercial]), [Nombre Comercial])

Expression is simple Sum([Normalised Average Cost])

And then check the suppress value is null

Re: Bar Chart With Top 10 Values along with Selected Field

shabarish0587 — Tue, 16 May 2017 10:15:39 GMT

Thank You Anil

Re: Bar Chart With Top 10 Values along with Selected Field

oknotsen — Tue, 16 May 2017 11:46:56 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .