topic Re: Sorting of latest 4 months data in bar chart using dimensional limits in QlikView

Sorting of latest 4 months data in bar chart using dimensional limits

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

Hi All,

I am trying to display latest four months data in a bar chart and my sorting is not properly working. Currently it is getting displayed as shown below. But I need the monthyear to be displayed in right to left descending

What I am doing currently doing is

Create a monthsort field as below

year(TempDate)&num(month(TempDate),'00') as monthsort

Use monthsort field for sorting

Show only first 4 values in dimensional limits as below

How to make this sorting proper Nov-17 on right hand side . Please suggest

Thanks and Regards

Praveena

Re: Sorting of latest 4 months data in bar chart using dimensional limits

vinieme12 — Mon, 27 Nov 2017 09:41:56 GMT

can you post the full screenshot? just to make sure you don't have anything else check except Sort by Expression for Month field and nothing for region field

also try below

NUM(year(TempDate)&(month(TempDate),'00')) as monthsort

Re: Sorting of latest 4 months data in bar chart using dimensional limits

dinuwanbr — Mon, 27 Nov 2017 09:45:12 GMT

Hi,

Instead of first 4 select largest 4 in limit dimension and sort ascending order.

PFA

Rgds,

Tharindu

Re: Sorting of latest 4 months data in bar chart using dimensional limits

Anonymous — Mon, 27 Nov 2017 10:00:32 GMT

HI tharindhu and Vineet

Thank you fr your prompt response

Setting largest values gives me something like below

Nov, Oct missing as Largest will take the largest will return the values based on first expression in the chart. My Nov. oct values are smaller than other months data and it is missing

Re: Sorting of latest 4 months data in bar chart using dimensional limits

dinuwanbr — Mon, 27 Nov 2017 10:17:04 GMT

Hi,

Can u upload a sample.

Rgds,

Tharindu