topic Re: Sorting in charts in QlikView

Sorting in charts

Anonymous — Tue, 24 Oct 2017 18:56:08 GMT

I have a below table

Account Product investor value

12343 Abcd Sam 20000

12322 Abbcd Bob 40000

12333 asdf Jack 34234

12344 Abcd Roger 234543

I just want to plot a bar chart accounts with the top 5 values. I was able to create the chart with Account as the dimension and value in the expression. I wanted to display only the top 5 values, so in the dimension limitation, I limited to the largest 5.

The display in the chart I get the top 5 account numbers and the corresponding values. The chart needs to be sorted in the value but it gets sorted on the account number.

Can someone help me get this chart sorted in values? I need this chart sorted in the expression field.

Re: Sorting in charts

krishnacbe — Tue, 24 Oct 2017 19:05:35 GMT

Hi,

Uncheck all options for the Account Dimension in Sort Tab. Check the Sort By Expression option and add your expression to sort.

Re: Sorting in charts

Anonymous — Tue, 24 Oct 2017 19:10:55 GMT

the Expression i have used is money(value) .

It doesnt work with the sort by expression.

Re: Sorting in charts

sergio0592 — Tue, 24 Oct 2017 19:14:48 GMT

Try with sort by Y value :

Re: Sorting in charts

krishnacbe — Tue, 24 Oct 2017 19:20:51 GMT

Hope the Attached file helps you.

Re: Sorting in charts

Anonymous — Wed, 25 Oct 2017 07:05:01 GMT

I missed some data, the sorting works when there is one record for each account when there is more than one record the sorting does not work.

Account	Product	investor	value
12343	Abcd	Sam	5000
12335	Abbcd	Bob	24003
12321	asdf	Jack	2142
12342	Abcd	Roger	12426
12343	Abbcd	Sam	80020
12343	asdf	Sam	400

Please find the data above. I tried using the max(value) in the expression but that does not give the top 5 values in the chart.

Want the chart to show the top 5 values and its corresponding Account numbers irrespective of the repeated account numbers

Re: Sorting in charts

krishnacbe — Wed, 25 Oct 2017 13:12:18 GMT

In Expression you have used Max function, which filters your second value for same value. in Chart the dimension will be aggregated based on you expression.

Re: Sorting in charts

Anonymous — Wed, 25 Oct 2017 13:55:04 GMT

Yes, I need an expression instead of it to display the chart showing the top values and respective account even if the account has two top values it should display in the chart

Can you please help on that ?