Sorting value in Line chart

Anonymous — Sat, 12 Sep 2015 14:01:24 GMT

Hello All,

I am preparing a Line where my Dimensions are State and month. In the line chart, I am trying to represent the accident reported in each month from all state. In the line chart, I am showing Top file states having more accidents each month.

State Month Accident Count %

A Jan'15 100

A Feb'15 150

A Mar'15 140

B Jan'15 80

B Feb'15 100

B Mar'15 110

B Jan'15 180

B Feb'15 110

B Mar'15 140

Percentage calculation will happen accident reported each month for each state/total accident reported. I want to my Line chart to show top 5 states having highest accident on a monthly basis but the value which will represent on the chart would be % of accident.

In short, top 5 states having highest accident count month on month.

Hope i explained it well.

Thanks in advance.

Regards,

Imran Khan

Re: Sorting value in Line chart

jduenyas — Sat, 12 Sep 2015 14:34:56 GMT

Set the state to be the first dimension.

In the Sort tab /Sort By, check the box "Y Value".

In the Presentation tab, check the Maximum Visible Number and enter 5 next to it.

Hope this helps if I understood it correctly.

Re: Sorting value in Line chart

ecolomer — Sat, 12 Sep 2015 15:04:23 GMT

See this example

Re: Sorting value in Line chart

ecolomer — Sat, 12 Sep 2015 15:05:48 GMT

Or this:

topic Re: Sorting value in Line chart in QlikView

Sorting value in Line chart

Re: Sorting value in Line chart

Re: Sorting value in Line chart

Re: Sorting value in Line chart