topic Re: Sorting in a bar chart in QlikView

Sorting in a bar chart

er_abhichandra — Mon, 15 Dec 2014 10:20:09 GMT

Hi,

I have a bar chart with two dimensions, Year and ProductType. I am displaying the current YearQtr plus last 4 YearQtrs, based on selections.

I am trying to sort the Product types in a particular order through expression in Sort tab.

The problem I am facing is that the products are getting sorted only for the Year and quarter selected in the filters. for the last 4 YearQtr it is not sorting in the same order. If i select multiple Years or Qtrs, then for those YearQtrs, the ProductTypes are getting sorted. I haven't faced this kind of behaviour before. Usually it sorts for the entire chart irrespective of selections.

Your thoughts?

Thanks,

Abhinava

Re: Sorting in a bar chart

Mon, 15 Dec 2014 10:31:48 GMT

Hi,

try to sort the Table using Inline table. for example if you want to sort like Months in the order you want you create an inline table and give the table the format you want. you can choose which month to start with and which names to display. like this

LOAD * INLINE [

Maand, MonthSort1

1, okt

2, nov

3, dec

4, jan

5, feb

6, mrt

7, apr

8, mei

9, jun

10, jul

11, aug

12, sep

];

Re: Sorting in a bar chart

er_abhichandra — Mon, 15 Dec 2014 10:38:07 GMT

Hi Abdallah,

I have tried that. it doesn't work.

any other option?

Thanks,

Abhinava

Re: Sorting in a bar chart

saumyashah90 — Mon, 15 Dec 2014 10:41:16 GMT

can you please attach the file or example??

Re: Sorting in a bar chart

ashishkalia — Mon, 15 Dec 2014 10:46:44 GMT

Abhinav

Can u please share some data or qvd relevant to that....???

Re: Sorting in a bar chart

er_abhichandra — Mon, 15 Dec 2014 10:48:01 GMT

Hi Saumya... I am attaching a screenshot of the chart. The six producttypes have to be sorted from top to bottom of the chart. only the bar related to selected YearQtr is being sorted. Rest are in some random order. The chart that I am talking about is Mktg Source ones.

Thanks,

Abhinava

Re: Sorting in a bar chart

saumyashah90 — Mon, 15 Dec 2014 10:54:07 GMT

Both Bar Chart and Stacked Chart seems have the same sorting order if i am not wrong.

Re: Sorting in a bar chart

er_abhichandra — Mon, 15 Dec 2014 10:56:29 GMT

Thats correct Saumya. Both Mktg Source stacked bar chart have to have same sorting order.

Thanks

Abhinava

Re: Sorting in a bar chart

saumyashah90 — Mon, 15 Dec 2014 11:00:50 GMT

So what is your question. Both seems to have the correct sorting order?

Re: Sorting in a bar chart

er_abhichandra — Mon, 15 Dec 2014 11:04:09 GMT

No Saumya, Only the YearQtr pertaining to the selected Year & Qtr is being sorted, rest of the Year Qtrs are not being sorted in the order specified.

Thanks,

Abhinava

Re: Sorting in a bar chart

saumyashah90 — Mon, 15 Dec 2014 11:10:04 GMT

You can check on 3 options and let me know.

1)Check where Date format for each field defined is same(Year,Quarter also).

2)under Sort tab uncheck all and check only State.

3)If problem persist uncheck State and check in Expression,Put your date field for quarte /year and save it and check

Re: Sorting in a bar chart

ashishkalia — Mon, 15 Dec 2014 11:13:38 GMT

Dear Abhinav its bettr if u create id for each quarter-Year and then sort then according to this ID.

Wat u need to do is to go to the script and in ur calander tab take resedent of ur calander and generate id like

LOAD DISTINCT Quarter-Year,

RowNo() as Qtr-Year_ID,

RESIDENT CALANDER;

and then go to the chart and sort tab and sort according to that Qtr-Year_ID.....
I hope that may help.

Re: Sorting in a bar chart

er_abhichandra — Mon, 15 Dec 2014 13:12:32 GMT

Hi Ashish, I am not trying to sort by YearQtr.. that is already done. I am tryin gto sort by the Product Type in a specific order.

Thanks,

Abhinava

Re: Sorting in a bar chart

chematos — Mon, 15 Dec 2014 13:34:45 GMT

Hi,

You can use match() function in order to sort by products.

Use something like this in the Expression combo in Sort menu:

=match (only(Product), 'Product1', 'Product2', 'Product3', 'Product4')

Regards,

Jose

Re: Sorting in a bar chart

Mon, 15 Dec 2014 13:43:16 GMT

In the expression of sort tab put your expression which you have for the product types and then select ascending.

Re: Sorting in a bar chart

Mon, 15 Dec 2014 13:46:47 GMT

Are you saying that you need stacked colours in a bar should be in the same order as you have used them in legend or whole bars should be sorted by product type's expression?

Re: Sorting in a bar chart

er_abhichandra — Mon, 15 Dec 2014 13:48:33 GMT

The stacked colours in a bar should be of same order as in the legend.

Thanks,

Abhinava

Re: Sorting in a bar chart

Mon, 15 Dec 2014 13:59:17 GMT

Have you tried the persistent colours option under colours tab?

Re: Sorting in a bar chart

Tue, 30 Dec 2014 22:38:53 GMT

If your problem is solved, its better to close this thread by choosing the right answer or posting it.